USING ALIASES

COLUMN ALIASES

Syntax:

     Select <orginal_col> <alias_name> from <table_name>;

Ex:

     SQL> select no sno from student;

or

     SQL> select no “sno” from student;

TABLE ALIASES

If you are using table aliases you can use dot method to the columns.

Syntax:

     Select <alias_name>.<col1>, <alias_name>.<col2> … <alias_name>.<coln> from

                                                       <table_name> <alias_name>;

Ex:

     SQL> select s.no, s.name from student s;