USING SELECT STATEMENT

Using SELECT Statement is used to retrive the data from database ,using this select statement
to retrive data from database in different manner as shown bellow

Retrive all records in table

SELECT * FROM EMP(TABLENAME);

Retrive Some records in table

SELECT ENO,ENAME,JOB FROM EMP;

Count the no of records in table

SELECT COUNT(*) FROM EMP;

Display the system time

SELECT DATATIME FROM DUAL;

4QKNMVMSF28H