Contents :

PL/SQL

Introduction to SQL What is database DBMS What is SQL SQL data type & operator Data Definition Laungauge Data Manipulation Laungauge Data Control Laungauge SQL Commands SQL SELECT SQL WHERE SQL UPDATE SQL DELETE SQL INSERT INTO SQL Advanced SQL Order By SQL AND & OR SQL In SQL Between SQL Aliases SQL Join SQL Union . SQL Functions SQL Select Into SQL Create View Nested Queries DATA MANIPULATION SQL Create table SQL Delete Table SQL Create index SQL Drop index SQL Alter Table SQL Function What is SQL Function? Aggregate Function Scalar function SQL Group By and Having PL/SQL Basic structure of PL/SQL Variables and type Simple program in PL/SQL Control flow in PL/SQL Cursors Printing variables