4.   Retrieving Data from  Oracle Server Database using Select SQL Statement.

• The Basic Query Block.
• Arithmetic Expression.
• Literals & Concatenation.
• Handling Null Values.
• Ordering Result sets using order by Clause.
• Limiting Output Rows using Where Clause.
• The Distinct Clause.
• Column Aliases.
• Negating Expresssion.
• Querying Data with Multiple condition.
• Retrieving Data from Multiple Tables with Inner, Left, Right, and Outer joins.
• Grouping Data with Group by Clause having Clause.
• Single Row Functions.
• Multi Row Functions.
• Substitution Varaibles in SQL Plus.
• Subqueris.

5.   Data Manipulation (DML).

• Inserting Data in Tables.
• Updating Data in Tables.
• Deleting Data in Tables.

6.    Data Definition (DDL).

• Creating Tables, Indexes, Views and Sequences.
• Modifying Structure of Existing Tables, Indexes, Views.
• Removing Structure from the Database.

7.    Data Controlling (DCL).

• Creating User.
• Granting Rights to Oracle user.
• Revoking Rights.
• Working with Oraccle roles.

8.   Overview of PL/SQL Programming.

• Procedural Programming Concepts (Commands, Loops, Conditions).
• PL/SQL Procedure, Function and Packages.
• Structure of PL/SQL Procedure/Function (Basic Block, Declaration Block, Exception Block).

9.   Developing PL/SQL Procedure.

• Creating a procedure.
• Declaring Variables and Constants.
• % type Attribute.
• Conditional Statement.
• Loop Statement.
• Working with Explicit Cursor.
• Error/Exception Handling Techniques.

Level 1:Foundation | Level 2:Application Development Tools | Oracle Forms | Oracle Reports |
Level 3:Database Administration | | Oracle on the Net | Back | Home