PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Code and test the EXECUTE IMMEDIATE command to create and execute SQL at run-time.
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.
Utilize the DBMS_UTILITY to return version data of the database.
Oracle PL/SQL Compilation
Convert PL/SQL stored procedures to native code shared libraries which are linked into the kernel.
Detect a performance issue using the Oracle profiler.
Using SQL Developer, debug a procedure supplied by the instructor.
Store a computed value into a SQL PLUS variable as a host variable; use the host variable in a generated report.
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.
Code a procedure using positional, named, or mixed notation for subprogram parameters.
Develop a package with a generalized routine; the instructor will provide the application.
Manipulating large objects
Create a table with Internal LOBs and retrieve the data for display in a web browser.
Create autonomous triggers and test the trigger with INSERTS, DELETES, and UPDATES
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.