This subject introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. Students will also learn to develop stored procedures, functions, packages and database triggers, manage PL/SQL program units, manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages.
No offerings have been identified for this subject in 2019.
SY/US
One session
School of Computing and Mathematics
Only for students enrolled in the following courses:
Master of Database Design and Management
Master of Networking and System Administration
Master of Systems Development
Master of Information Systems Security
Master of Management (IT) - MMgtInfoTech
Graduate Certificate in Management (IT) - GradCertMgtInfoTech
ITI500
- be able to design PL/SQL anonymous blocks that execute efficiently;
- be able to describe the features and syntax of PL/SQL;
- be able to use PL/SQL programming constructs and conditionally control code flow;
- be able to handle runtime errors;
- be able to create simple procedures and functions;
- be able to design PL/SQL packages to group and contain related constructs;
- be able to schedule PL/SQL jobs to run independently;
- be able to write dynamic SQL for more coding flexibility;
- be able to manage dependencies between PL/SQL subprograms.
Introduction to PL/SQL.
Declaring PL/SQL Identifiers.
Interacting with the Oracle Server.
Working with Composite Data Types.
Using Explicit Cursors.
Handling Exceptions.
Creating Stored Procedures and Functions.
Utilizing Oracle Supplied Packages in Application Development.
Dynamic SQL and Metadata.
Design Considerations for PL/SQL Code.
Managing Dependencies.
Manipulating Large Objects.
Creating Triggers.
Applications for Triggers.
For further information about courses and subjects outlined in the CSU handbook please contact:
The information contained in the CSU Handbook was accurate at the date of publication: May 2019. The University reserves the right to vary the information at any time without notice.