Course Oracle PL/SQL

Duration (days): 3
Price (CZK): 13000

Oracle PL/SQL topics:

• Basics of PL/SQL
• PL/SQL architecture
• PL/SQL and SQL*Plus
• PL/SQL Basics, Variables, Constants, data types & error handling
• Simple blocks
• Control structures
• PL/SQL records
• Recognizing the Basic PL/SQL Block and Its Sections
• Distinguishing Between PL/SQL and Non-PL/SQL Variables
• Declaring Variables and Constants
• Executing a PL/SQL Block
• Exceptions handling
• Constructing and Identifying Different Loop Statements
• Controlling Block Flow Using Nested Loops and Labels
• If-then-else structure
• Cursors in PL/SQL
• Using a cursor for a multi-row SQL query
• PL/SQL tables, constrainst, indexes
• Introduction to the dbms_sql package
• Creating a dynamic SQL statement, EXECUTE IMMEDIATE
• Triggers in PL/SQL
• Triggers and database events
• Enabling and disabling a trigger
• Resolving mutating table problem
• Stored procedures, functions and packages
• Passing arguments to functions and stored procedures
• Recompiling functions and stored procedures
• Listing package information
• Bulking in PL/SQL
• Bulk queries
• Bulk DML (forall statement)
• Using cursor attributes
• Explaining DBMS_OUTPUT and SET SERVEROUPUT ON
• Usage UTL_FILE package to generate report to file
• Big file object manipulation via BFILE, BLOB, CLOB
• Big file object manipulation via DBMS_LOB

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs