| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
| Question: What is difference between Rename and Alias?
Answer:
Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed. |
| August 08, 2007 04:45:50 |
#6 |
| velsowmya |
Member Since: August 2007 Total Comments: 7 |
RE: What is difference between Rename and Alias?...
|
Rename is used for changing the name of the column or table.
where as alias is the command used tio change the column name for query purpose.
Basically alias are used mostly in joins |
| |
Back To Question | |
