PL/SQL 101 Office Hours February 6 2018
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. PL/SQL 101 Office Hours focuses on PL/SQL topics for beginners. In February, we took a look at the PL/SQL block. It is the fundamental, ahem, building block of PL/SQL program units. Without a solid grasp of blocks you can't write high quality PL/SQL APIs to your underlying data.
We also answered questions on pipelined table functions, when commits and rollbacks happen in PL/SQL program units, differences between local and global data, and more
Check out this LiveSQL script for block examples: https://livesql.oracle.com/apex/lives.... Feel free to check it out yourself.
Sign up for Office Hours sessions at https://asktom.oracle.com