Page 289 - aREA ix eXHIBITS

UNIT OF COMPETENCY: USE AND APPLY PL/SQL PROGRAMMING LANGUAGE

UNIT CODE : ICT313363

UNIT DESCRIPTION : This unit introduces the student to PL/SQL language and
explains the benefits of this programming language. The
student will learn to develop stored procedures, functions,
packages and other basic functions.

ELEMENT PERFORMANCE CRITERIA
Italicized terms are elaborated in the Range of Variables
1. Declare PL/SQL 1.1 PL/SQL language is introduced in accordance with
Identifiers PL/SQL framework
1.2 List the different Types of Identifiers in a PL/SQL
subprogram in accordance with PL/SQL framework
1.3 Declarative Section to Define Identifiers are used in
accordance with PL/SQL framework
1.4 Variables to store data are used in accordance with
PL/SQL framework
1.5 Scalar Data Types are identified in accordance with
PL/SQL framework
1.6 Sequences in PL/SQL Expressions are used in
accordance with PL/SQL framework
1.7 Executable Statements are written in accordance with
PL/SQL framework

2. Apply Interaction with 2.1 SELECT Statements in PL/SQL are invoked in
the Oracle Server accordance with PL/SQL framework
2.2 Data in PL/SQL are retrieved in accordance with
PL/SQL framework
2.3 Errors by using Naming Conventions when using
Retrieval and DML Statements are avoided in
accordance with PL/SQL framework
2.4 Data in the Server using PL/SQL is manipulated in
accordance with PL/SQL framework
2.5 SQL Cursor Attributes to Obtain Feedback on DML are
used in accordance with PL/SQL framework

3. Apply Exception 3.1 Exceptions are understood in accordance with PL/SQL
Handling framework
3.2 Exceptions with PL/SQL are handled in accordance
with PL/SQL framework
3.3 Predefined Oracle Server Errors are trapped in
accordance with PL/SQL framework
3.4 Non-Predefined Oracle Server Errors are trapped in
accordance with PL/SQL framework
3.5 User-Defined Exceptions are trapped in accordance
with PL/SQL framework
3.6 Exceptions are propagated in accordance with PL/SQL
framework

_________________________________________________________________________________ 34
TR – Programming (Oracle Database) NC III Promulgated – December 2013