ORACLE Part 2

-------------- SQL STATEMENTS ----------------------

Data Retrieval
Select

Data Manipulation Language (DML)
Insert, Update, Delete, Merge

Data Definition Language (DDL)
Create, Alter, Drop, Truncate, Rename

Data Control Language (DCL)
Grant, Revoke

Transaction Control
Commit, Rollback, Savepoint

Data Retrieval (Select Statement) -- Capabilities

1. Projection : Select All or Particular Columns From the table
2. Selection : Select All or Particular Columns From the table including Where Clause
3. Joining : Retrieve Data from more than One Table

To Retrieve all the Data from the Table
Select * from Emp;

To Retrieve particular Data from the Table
Select empno, ename, sal from Emp;

To Retrieve particular Data from the Table including Where Clause
Select empno, ename, sal from Emp where deptno = 10;

You can Edit your previous queries through Oracle SQL* Plus, there you have to use Notepad Functionality for it, For this you have to type.
ED