Some time age one of my colleagues, An V., played with the idea to start a company magazine. Everybody liked the idea and our manager gave a green light to create “De Poreiflash”. Why it’s called “De Poreiflash” is a long story and I have to kill you when you don’t work for iAdvise and I tell you this.
But to keep the story short, she asked colleagues to contribute and asked me if I could write something about PL/SQL.
Sure I wanted to do that! But about what in PL/SQL? There so much to talk about…
I got “carte blanch”, so I started looking for topics: hints and tips, must know features, technical solutions,…
What else comes up when thinking about PL/SQL?
Wouldn’t it be cool to start with an interview with Steven Feuerstein?
I contacted Steven and he was prepared to answer some questions for “De Poreiflash”.
The first issue of “De Poreiflash” appeared two weeks ago. An did a great job with our company magazine, it looks fantastic!
And here’s the interview how it appeared in “De Poreiflash”.
Somethings are already outdated: in the meantime Steven became a grandfather!
Q. Steven Feuerstein, the person with a PL/SQL obsession. Introduction is probably not needed for people working with Oracle. Maybe a short one?
Sure. Well, yes, I think I do qualify as having an obsession about PL/SQL. I’ve written 10 books on the language and have spent most of my professional life since 1994 reading about, writing about, writing and generally wrestling with PL/SQL. Along the way, I’ve gathered some awards and related projects: I’ve been developing software since 1980, spent five years with Oracle (1987-1992), and have served as PL/SQL Evangelist for Quest Software since January 2001.
I am an Oracle ACE Director and write regularly for Oracle Magazine, which named me the PL/SQL Developer of the Year in both 2002 and 2006. I am also the first recipient of ODTUG’s Lifetime Achievement Award (2009).
In 2010, I started the PL/SQL Challenge, an online, daily PL/SQL quiz (now also offering weekly APEX, SQL and logic quizzes). In 2011, I launched PL/SQL Channel, a library of over 27 hours of detailed training on Oracle PL/SQL.
Q. How did you enter the Oracle world and got obsessed with PL/SQL?
I “fell” into the world of Oracle entirely by chance. I came out of university a Fortran programmer and ended up at Abbott Laboratories as a consultant, during which time I was introduced to databases on DEC10s and DEC20s. From there, I moved to CNA (insurance) in downtown Chicago and that was an incredibly boring job, though I did spend more time with a non-relational database while there.
So, bored out of my mind, with a newborn baby eating me out of house and home, I decided to look for a new position, and came across a Help Wanted ad looking for a person with relational database experience. Well, one of those words was familiar! So I got hold of an article on relational databases (Codd’s 12 rules), memorized that, and went to the interview. Turned out to be for a pre-sales job with Oracle. They were more interested in my ability to speak to large groups than my technical background. In any case, I was hired – the main issue for me was deciding whether or not I wanted to take a job that required wearing a suit and tie every day.
I spent a couple of years following salespeople around to accounts and doing the dog-and-pony shows for them with SQL*Plus, SQL*Forms, etc. Presales was interesting and sometimes exciting, but programming was way better, so I would constantly dabble with the Oracle tools, building little apps for my co-workers to use. This developed into TeamSell, a sales support application that caught the eye of Mike Fields, head of U.S. Sales in the early ’90s. I was drafted to join a small dev team and we started building some very cool SQL*Forms apps to support the U.S. sales force.
Then Larry canned Mike, and I was told to go back out on the road to help sell Oracle. I said no thanks, and took the first consulting job I was offered. Two years later, I saw an appeal on CompuServe for Oracle authors and I thought “Why not? I can write.” So I wrote Oracle PL/SQL Programming, which was the first independent text on PL/SQL, and it changed my life. From that point on, I was virtually a full-time student of the PL/SQL language, researching, writing, teaching, building code, etc. As I mentioned earlier, once you can structure your own time, all it takes is disciplineand reasonably good typing skillsand you can accomplish an awful lot!
I can still remember thinking as I signed the contract with O’Reilly that stipulated a book of 400 pages: “Is there really that much to write about PL/SQL?” 1200 pages later, we had to cut 400 pages to publish the first edition. Those 400 pages were all about writing PL/SQL in Oracle Forms and Reports. We should have published that immediately as a “side book.” Ah well….
Q. What’s your current job?
I am the PL/SQL Evangelist for Quest Software, have been since 2001. What this means, for the most part, is that Quest gives me lots of freedom to continue to explore the language, and support the worldwide PL/SQL community. Of course, I also do some product development, design and marketing. But I do think that Quest deserves lots of credit and a big thank you from PL/SQL developers around the world for making it possible for me to maintain my expertise and help other developers around the world.
Q. Other activities?
Ah, well, I used to play racquetball, go on lots of long bicycle rides, all sorts of things. Now, as I move through my sixth decade on Planet Earth, I find myself spending more time than ever in front of my laptop (believe me, it is not easy to write five new PL/SQL quizzes each week!) and THAT IS NOT A GOOD THING. So I struggle to keep my body in decent shop and avoid the problems associated with lots of typing and lots of staring at screens. But soon I will have a major new activity: I will be a grandfather by early November. Very exciting!
Q. About the PL/SQL Challenge… What is it?
The PL/SQL Challenge is my latest and greatest effort to (a) coalesce an active, engaged, global community of PL/SQL developers, and (b) “download” my PL/SQL expertise from my brain into a format that is accessible to all developers and will be around long after I am gone. There are lots of sites that offer Q&A for PL/SQL and SQL; I am not interested in providing another of those. Instead, I think that developers are like “normal” human beings: we like to compete, we like to win prizes, we like to be recognized, we like to be challenged.
The PL/SQL Challenge does all of that: you take daily, weekly and monthly quizzes, competing with hundreds (and hopefully soon thousands) of other Oracle technologists. Of course, you don’t have to “compete”. You can simply take the quizzes (using, by the way, a nickname that does not reveal your true identity) as another way to deepen your knowledge of PL/SQL and related technologies like SQL and APEX.
So today it is a totally free quiz-driven learning experience. Soon, we will make it possible for you to join the PL/SQL Challenge by paying a small annual membership fee. Members will be able to utilize special features such as Practice Makes Expert, in which you can take past quizzes as often as you like, thereby sharpening your command of the PL/SQL language, and Quizbook, which will allow you to export quizzes as PDF “books” that you can use when away from the website – or to present to your manager to show her how much effort you are making to improve your technical skills.
If you haven’t registered and tried out the PL/SQL Challenge, I strongly encourage you to do so!
Q. Why should one participate?
Why not? It just takes a few minutes a day, and you are sure to either learn something new or demonstrate to everyone that you are well-versed in that particular feature of PL/SQL. When you play, you have the chance to win some prizes (ranging from O’Reilly ebooks to $250 Amazon.com gift cards).
Q. Some tips about developing PL/SQL? Eg. on performance or hardcoding.
If you are not thoroughly comfortable with and applying everything on the list below, then you have a clear set of next steps when it comes to your PL/SQL training:
- BULK COLLECT and FORALL
- Autonomous transactions
- Function result cache
- Table functions
Q. Can you recommend books, websites, presentations,… about PL/SQL?
There are lots of excellent Q&A forums for PL/SQL, with the OTN forum being about the best. Stackoverflow.com also attracts lots of PL/SQL-related questions.
Another great site for PL/SQL developers is oracle-developer.net, provided by Adrian Billington.
Tim Hall’s ORACLE-BASE.com is also an excellent all-around resource for Oracle technologists.
I do encourage your readers to check out all the sites and resources I’ve been putting together in recent years:
- PLSQLChallenge.com – play and learn!
- PLSQLChannel.com – watch and learn!
- ToadWorld.com/SF – the PL/SQL Obsession site. Lots of resources to download and leverage
- StevenFeuerstein.com – sign up for my monthly PL/SQL newsletter
- ILovePLSQLand.net – vote on proposed enhancements to the PL/SQL language
Q. With your books and presentations you inspired a lot of PL/SQL developers. How does that feel?
It feels great! I expect that many companies have indirectly benefited from my writings. But what I find most rewarding is the impact I have had on the lives of individual programmers. It is not terribly uncommon to have a person walk up to me at a conference or training and offer up a variation on this story, told to me back in 1998: “I was a union electrician at a steel mill in northern Indiana. When I got laid off, I went back to school and studied Oracle programming. I got hold of your book and it changed my life. Now I have a great job, my wife doesn’t have to work and can raise our kids.” Ah, that is so satisfying!
Now, just to make sure there is no misunderstanding: I am not saying that I think everyone should follow a lifestyle in which the man works and the wife stays home with the kids.
But to have a developer tell me his or her life was changed by my writing? Wow, what could be better? So, dear readers, don’t ever hesitate to send me an email (mailto: firstname.lastname@example.org) or tell me in person about the impact my work has had on your life. I can’t get enough of that!
Q. A last message to our readers?
I just turned 53 years old. I’ve been writing software rather intensively since 1980. Thirty years of programming, thirty years of (largely) sitting in front of keyboards and screens.
It’s been a great life (and I expect lots more good years to come), but I feel more and more of late that I haven’t maintained enough of a balance. There’s a very big world out there beyond my laptop, and I should be experiencing more of it.
So that will be my last message for your readers: Enjoy writing your software, but don’t let it consume your life!