ITI588 Programming with PL/SQL (8)

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.

Subject Outlines
Current CSU students can view Subject Outlines for recent sessions. Please note that Subject Outlines and assessment tasks are updated each session.

No offerings have been identified for this subject in 2018.

Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject Information

Grading System



One session


School of Computing and Mathematics

Enrolment Restrictions

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



Learning Outcomes

Upon successful completion of this subject, students should:

- 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.


This subject will cover the following topics:

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.


Current Students

For any enquiries about subject selection or course structure please contact Student Central or or phone on 1800 275 278.

Prospective Students

For further information about Charles Sturt University, or this course offering, please contact info.csu on 1800 275 278 (free call within Australia) or enquire online.

The information contained in the 2018 CSU Handbook was accurate at the date of publication: August 2018. The University reserves the right to vary the information at any time without notice.