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
Watch video PL/SQL 101 Office Hours February 6 2018 online without registration, duration hours minute second in high quality. This video was added by user Practically Perfect PL/SQL with Steven Feuerstein 07 February 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,290 once and liked it 56 people.