What I will learn?

• Declare PL/SQL Variables
• Use some of the Oracle supplied PL/SQL packages to generate screen output
• Use PL/SQL packages to group and contain related constructs
• Perform Data processing using Records and Cursors
• Create triggers to solve business challenges
• Execute SQL using Dynamic SQL
• Working with Large Objects (LOB's)
• Conditionally control code flow (loops, control structures)
• Create anonymous PL/SQL blocks, functions and procedures
• Catch run time errors using Exceptions
• Manage data using Collections
• Perform Bulk Processing to improve performance
• Pipelining the data as it is processed