No offerings have been identified for this subject in 2017
ITI588 Programming with PL/SQL (8)
Abstract| 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 Availability Modes and Location
Continuing students should consult the SAL for current offering details prior to contacting their course coordinator: ITI588
Where differences exist between the handbook and the SAL, the SAL should be taken as containing the correct subject offering details.
|
|
Subject information| Duration | Grading System | School: |
|---|
| One session | SY/US | 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 OutcomesUpon 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. |
|
|
SyllabusThe 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. |
|
|
Back
The information contained in the 2017 CSU Handbook was accurate at the date of publication: 25 August 2017. The University reserves the right to vary the information at any time without notice.
