My specialty is the Oracle PL/SQL language. You might even call it my obsession. I first started using PL/SQL during my first stint at Oracle, from 1987 to 1992. I used it in SQLForms 3, the first place that PL/SQL appeared. That was an enormous improvement over the SQLForms 2.x trigger logic.
PL/SQL got really exciting, though, with version 7 of Oracle Database, when the PL/SQL dev team added full support for packages and other stored program units, exception handling, embedded (static) SQL, and so much more.
I left Oracle in 1992 and became a consultant. I’d always liked to write and when in 1994 publishers realized there was a large-enough market of Oracle Database developers, I took a chance and signed up to write a book called Oracle PL/SQL Programming for O’Reilly Media.
It was the first independent reference on PL/SQL (that is, not Oracle documentation) and it was a big hit, relatively speaking. It became popular enough to be called “the Bible for PL/SQL developers” and free me up from daily consulting, so I could devote myself fully to helping developers make the most of PL/SQL.
Which I did, first as a PL/SQL evangelist for Quest Software (and then Dell), up through 2014. Then I returned to Oracle Corporation to lead a team of Developer Advocates.
Along the way, I trained thousands of developers, wrote ten books on PL/SQL (yes, ten, about 6 too many, I figure looking back), countless articles and blog posts. I recorded hundreds of videos on the topic, visited dozens of countries to present at conferences. I’ve also picked up a few speaker awards, and was one of the first Oracle ACE Directors.
I also created a website called the PL/SQL Challenge that offered daily ranked quizzes on PL/SQL. At its peak we had over 2000 developers taking the quizzes each day. That website was transformed into the Oracle Dev Gym (https://devgym.oracle.com), which now offers quizzes, workouts and classes on SQL, PL/SQL, database design, logic and more. All free, of course.
Yet even the best job in the world can get, well, repetitive after awhile. There will always be more to say and write about PL/SQL, certainly. But after almost 7 years at Oracle (in my second round), I decided it was time for a change. I wanted to work more closely with developers who were doing the work (delivering solutions for customers with PL/SQL) and I wanted to help make Oracle Application Express (APEX) more successful. So I joined Insum on Feb 1 2021!
POUG is not only the official Oracle community – first of all it is the base of very active members, who are engaged in the group development both during the meetings and the preparations to them. Our message gets to the 400 people connected with databases – from the developers to the administrators and from the begginers to the experts with years of experience.
We would like to invite you to be a part of our event – it is a chance to show your brand during and before the meeting.
Ta strona wykorzystuje własne pliki cookies, aby działać prawidłowo. Korzysta też z plików cookies podmiotów trzecich, dostarczających narzędzia marketingowe, usługę newslettera, odtwarzacze wideo, mapy oraz narzędzia analityczne. Do informacji zbieranych w cookies podmiotów trzecich mają dostęp dostawcy tych narzędzi. Czy zgadzasz się na korzystanie z innych niż niezbędne plików cookies zgodnie z polityką prywatności?
If you’re visiting this site, it’s a sign that you value your privacy. To meet your expectations, this page has implemented a mechanism that allows you to control the use of cookies and other tracking technologies.
First-party cookies are used on this site to ensure the proper functioning of certain website features, and third-party cookies are used to utilize external tools as described in detail in our privacy policy.
If you want to accept all cookies used here, click the button below.
I accept all cookiesThese cookies are always active, and you cannot opt out of them. These include cookies that ensure the proper functioning of features like forms on the site, the user account login mechanism, and maintaining sessions after logging in. Additionally, your cookie settings are stored in first-party cookies.
We use Google Analytics, a tool that allows us to collect, review, and analyze statistics related to user activity on our website. The Google Analytics tracking code collects information about your activity on our website, which Google may use to build your user profile. Additionally, Google Analytics data may be used in ad campaign settings with Google Ads. If you do not wish for this, you can disable Google tools.
We use Facebook marketing tools. Therefore, we have embedded Facebook's analytical scripts (Facebook Pixel) on the website, which collect information about your activity on this site and your IP address. Based on the information gathered, Facebook allows for setting up ads with advanced targeting options. If you do not wish for this, you can disable Facebook's analytical scripts.
We use multimedia from YouTube on this site. The players for this multimedia use cookies from their provider. The provider may access the information stored in the cookies and your IP address. This information is used to ensure the proper functioning of the players and for analytical purposes. You can choose not to allow cookies related to the players, but in that case, you will not be able to view the embedded multimedia content.
We use Google Maps on the site. These maps use cookies provided by the service provider to function correctly. The service provider may access the information collected in these cookies, as well as your IP address. You can disable the cookies related to maps, but if you do, you will not be able to view the maps on our website.
Osadziliśmy na stronie formularz pozwalający Ci zapisać się do naszego newslettera. Formularz wykorzystuje do swojego prawidłowego działania pliki cookies pochodzące od dostawcy systemu newsletterowego MailerLite. Dostawca może uzyskiwać dostęp do informacji gromadzonych w plikach cookies oraz Twojego adresu IP. Informacje te wykorzystywane są w celu zapewnienia prawidłowego działania formularza oraz w celach analitycznych. Możesz wyłączyć pliki cookies związane z formularzem, ale w takiej sytuacji nie będziesz w stanie zapisać się do newslettera.
