Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Oracle: PL/SQL Programming - Advanced


distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services


Oracle: PL/SQL Programming - Advanced
DURATION: 4 days

FEE: $1,980

Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

There is a surcharge associated with training two or fewer students.


  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional


    1. Dynamic SQL
      • Code and test the EXECUTE IMMEDIATE command to create and execute SQL at run-time.
    2. Collections
      • Code an associative array accessed via a string unique key to retrieve a value.
      • Get metadata object definition in the form of a DDL statement.
    4. Supplied Packages
      • Utilize the DBMS_UTILITY to return version data of the database.
    5. Oracle PL/SQL Compilation
      • Convert PL/SQL stored procedures to native code shared libraries which are linked into the kernel.
    6. Profiler
      • Detect a performance issue using the Oracle profiler.
    7. Debugging
      • Using SQL Developer, debug a procedure supplied by the instructor.
    8. Variable declaration
      • Store a computed value into a SQL PLUS variable as a host variable; use the host variable in a generated report.
    9. SQL Cursor
      • Declare and run a cursor using %FOUND to determine if any rows were extracted into the resultset.
      • Use the %ROWCOUNT attribute to determine how many rows have been affected after an UPDATE.
      • Create an explicit and explicit cursor using dynamic SQL..
      • Run a BULK COLLECT clause which will fetch all rows from the resultset at one time.
      • Code an update routine using a cursor with the WHERE CURRENT OF clause.
    10. Procedures
      • Code a procedure using positional, named, or mixed notation for subprogram parameters.
    11. Packages
      • Develop a package with a generalized routine; the instructor will provide the application.
    12. Manipulating large objects
      • Create a table with Internal LOBs and retrieve the data for display in a web browser.
    13. Database triggers
      • Create autonomous triggers and test the trigger with INSERTS, DELETES, and UPDATES

    Web-based Training   Blended Learning    


Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.