SQL and PL-SQL Tutorial 1.0

This comprehensive tutorial on Oracle SQL and PL/SQL provides a detailed exploration of definitions, syntax, and practical examples that are beneficial for both novices and experienced users alike.

Below is a list of the SQL topics included in the tutorial:

• Create Table
• Alter Table
• Rename and Drop Table
• Insert into Table
• Update and Delete Statements
• Transaction Control Statements
• SELECT Statement
• Components of SQL Statements
• Truncate Table
• BETWEEN Operator
• DISTINCT/UNIQUE
• Character Manipulation: CONCAT
• WHERE Clause
• INSTR Function
• DUAL (Dummy Table)
• SQL Functions
• Conversion Functions
• DECODE Function
• Implicit & Explicit Conversion
• Using CASE in SQL
• NVL, NVL2 & COALESCE
• Date Functions
• GROUP BY Clause
• GROUP BY Clause with Filter
• HAVING Clause
• Group Functions
• SQL Joins
• Inner Vs Outer Join
• COMMIT-ROLLBACK Data State
• Locking in SQL
• MERGE Statement
• Types of Tables
• RR & DD Date Format
• Pseudo-columns
• SQL Constraints
• Views & Inline Views
• WITH CHECK OPTION in Views
• Indexes
• Create User and Grants
• Synonyms

The following topics are covered in PL/SQL:

• PL/SQL Block
• Types of Variables
• SQL Functions in PL/SQL
• Conditional/Selection Control
• Loops in PL/SQL
• Cursors in PL/SQL
• Cursors with Parameters </ li >   
• PL/SQL Reference Cursors </ li >   
• Bulk Collect and Bulk Bind </ li >   
• PL/SQL Records Data Type </ li >   
• Composite Data Type - VARRAY </ li >   
• Composite Data Type - NESTED TABLES </ li >   
• Composite Data Type - INDEX BY TABLE </ li >   
• Implicit Exceptions </ li >   
• Explicit Exceptions </ li >   
• Exception Trapping Functions </ li >   
• PL/SQL PROCEDURE </ li >   
• PL/SQL FUNCTION </ li >   
• PL/SQL PACKAGE </ li >   
• Trigger </ li > </ ul >