DRL statement

In DRL (DATA RETRIEVAL LANGUAGE) we have SELECT statement.

Syntax:

SQL> select <col 1, col 2,...,col n> from <table name>.

SQL> select * from emp;

        ID NAME                SALARY                                         
---------- --------------- ----------                                         
         1 mohan               1500                                         
         3 suresh                7700                                         
         4 sohan                1900                                         
         7 sujit                   2200                                         

SQL> select  id,name from emp;

        ID NAME                                                               
---------- ---------------                                                    
         1 mohan                                                              
         3 suresh                                                             
         4 sohan                                                              
         7 sujit