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 2018.
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
- 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.
Creating Stored Procedures and Functions.
Utilizing Oracle Supplied Packages in Application Development.
Dynamic SQL and Metadata.
Design Considerations for PL/SQL Code.
Manipulating Large Objects.
Applications for Triggers.
For any enquiries about subject selection or course structure please contact Student Central or email@example.com or phone on 1800 275 278.
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.