Command: Select

To select columns..

select e_no, e_name, bdate, d_no, SSN from employee;

E_NO	E_NAME	BDATE	D_NO	SSN
45	Ajay	10-JAN-93	205	5578
46	Kumar	23-OCT-93	205	5579
47	Babu	08-JAN-93	205	5580
48	Ram	23-SEP-93	200	5581
49	Vignesh	03-MAR-92	200	5582

To Select Table..

select * from employee;