Aug 09, 2020
DA 262 - Oracle PL/SQL Programming I
Credit Hours: 3
PL/SQL, Oracle corporation's procedural language extension to SQL will be introduced in this course. Students will learn procedural logic constructs such as variables, constants, conditional statements and iterative controls. Students will explore some of the limitations of SQL and learn why PL/SQL is needed. PL/SQL key words and definitions and appropriate usages are introduced. Students also learn about the PL/SQL block structure, the basic unit in PL/SQL. Oracle Application Express, a browser based development environment will be used for coding PL/SQL blocks.
Upon completion, the student will be able to:
- describe PL/SQL and explain the difference between SQL and PL/SQL and why PL/SQL is necessary;
- code PL/SQL anonymous blocks using Oracle Application Express;
- apply PL/SQL syntax and lexical units including PL/SQL variables, constants, functions, data types, and nested blocks to the development of business application development;
- expand on the use of Data Manipulation Language (DML) to add, update, delete or merge data in the database by using implicit cursors and their attributes and how to group SQL statements for database transaction processing;
- use conditional control statements and iterative control statements to direct the flow of execution through a program;
- implement PL/SQL explicit cursors to allow multiple row retrieval from a database and programming code to process rows one at a time;
- code an exception handler so that programs do not terminate when PL/SQL raises an exception;
- create procedures and functions including parameter passing and user defined functions; and
- access the Data Dictionary and write SQL to retrieve data from the it's tables.
Prerequisites: DA 160, DA 161 or permission of the instructor.