Just getting started with PL/SQL? You will find PL/SQL to be a very readable and accessible programming language. You'll be productive in a very short amount of time! I offer this post as a quick way to access a number of resources that will provide a nicely-paced introduction to this powerful database programming language. Of course, it helps a lot to know SQL, too, so check out the Other Useful Links at the bottom of the post. I wrote a series of "PL/SQL 101" articles for Oracle Magazine several years ago. Here's a convenient index to all those articles: 1. Building with Blocks - an overview of PL/SQL, followed by coverage of some fundamentals 2. Controlling the Flow of Execution - conditional statements and loops 3. Working with Strings 4. Working with Numbers 5. Working with Dates 6. Error Management 7. Working with Records 8. Working with Collections 9. Bulk Processing with BULK COLLECT and FORALL 10...
For the last twenty years, I have managed to transform an obsession with PL/SQL into a paying job. How cool is that?