Equi Non Equi Self Join Cartesian Joinnatural joins Vertical joinsset operators

Equi non equi self join cartesian joinnatural joins

This preview shows page 3 - 6 out of 120 pages.

Equi / Non Equi / Self Join / Cartesian Join/natural joins Vertical joins(set operators) Sub Queries and Simple sub query Complex Sub Query on multiple data source and Co-related Sub Query Top-n queries, hierarchical queries, scalar queries, flashback queries,version queries. Intigrity Constraints Oracle Database Objects Index and Introduction to Index Clusters and Introduction to Cluster Type of Clusters and Their Usage Explain plan Command Usage and Oracle Scripts Views and Introduction to Views Type of Views and usage Performance issues with Views Background process of Views DML restrictions on Views Materialized View and Usage Synonym and Introduction to Synonyms and Usage Sequence and Introduction to Sequence and Usage Pseudo Columns Usage in Sequence Data Control Language commands What is privilege What is role Grating Privilege Removing Privilege Cascading Privilege Sql * Plus Commands
Image of page 3
ORACLE SQL Environment setting commands Alter session language Alter system language Sql developer PL/SQL Introduction to Programming Language Procedures Vs Non-Procedures Language Limitation of ANSI SQL and Oracle SQL Introduction to Oracle PL/SQL PL/SQL Usage in Production Database Key benefits of PL/SQL over SQL Anchor datatypes or Attributes Composite datatypes Collections PL/SQL block structure & Designing Scope and Visibility Constructs of PL/SQL Assignment operations Debugging statement Flow Control Statement IF / NESTED IF / EXIT / GOTO / Iterative statements Simple Loop / While Loop / For Loop Continue statement(11g) Embedded SQL Introduction to Embedded SQL Role of Embedded SQL in PL/SQL Constructs of Embedded SQL Transaction Mngmt Using Embedded SQL Dynamic SQL Introduction to Dynamic SQL Usage of Dynamic SQL in PL/SQL Introduction to Exceptions Importance of Exceptions in PL/SQL Type of Exceptions Exception handling Save exceptions Introduction and STANDARD Package Introduction to User Defined Exceptions Non predefined exceptions Exception cases Usage of PRAGMA EXCEPTION_INIT() Cursor Management in PL/SQL Introduction to cursor management
Image of page 4
ORACLE SQL Pictorial presentation of cursor mechanism Introduction and usage of implicit cursor Introduction and usage of Explicit cursors Cursor attributes Cursor using simple loop Cursor using while loop Cursor using for loop Cursor exceptions Cursor expression Data Locking Data Manipulation through Cursor REF cursor(strong and weak) Using ref cursor variable as parameter Bulk Fetch and Bulk Data Retrieval in PL/SQL Bulk Collection Bulk Binding mechanism of Cursor (for all statement) Dynamic behavior of cursor mnt.
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 120 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture