ORACLE SQL/PLSQL DEVELOPER

Course Outlines

• The SQL Select Statement

• Restricting and Sorting Data

• Using Single -Row Function

• Conversion Functions

• Conditional Expressions

• Using the Group Function

• Get Data from Multiple Tables

• subqueries to solve queries

• Using the set Operators

• Using DDL Statement

• Creating Other Schema Object

• Basic of PL/SQL

• PL/SQL block structure

• Anonymous block

• Procedure

• Function

• Trigger

• Cursor

• Exception handling

Course Introduction