Advanced PLSQL Programing 1 Agenda Problem solving with If loops How to handle errors How to process SQL output rowbyrow Create and Execute Stored Procedures 2 If IfElse Guide to Oracle 10g ID: 764618
Download Presentation The PPT/PDF document "Advanced PL/SQL Programing" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Advanced PL/SQL Programing 1
Agenda Problem solving with If / loops How to handle errors How to process SQL output row-by-row Create and Execute Stored Procedures 2
If / If…Else Guide to Oracle 10g 3
If…ElsIf …Else Guide to Oracle 10g 4
Loops Guide to Oracle 10g 5
Exceptions When an error occurs in your PL/SQL block execution can transfer to an exceptions area. This can be used to log data, raise errors, or rollback transactions. General Exception Block: Exception When others then raise; Guide to Oracle 10g 6
Exceptions Guide to Oracle 10g 7
Cursors Provide access into the individual rows of a select statement. You can loop over the SQL output and execute code that will apply to each row. Guide to Oracle 10g 8
Cursors Guide to Oracle 10g 9
Stored Procedures Save your PL/SQL code under a name Guide to Oracle 10g 10 234
Demo Time!!!! 1) Refactor Customer Lookup as SP. 2) Program to call 1) in loop handles exception. 11
Questions 12