| |
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 22:44:52 |
#5 |
| hari |
Member Since: Visitor Total Comments: N/A |
RE: What is difference between Rename and Alias?...
|
Rename of a column or table is a permanent change where alias is a object for a column or table where it can be referred instead of using a long column or table names. For eg. usage of alias is
1. Joins
2. Subqueries
|
| |
Back To Question | |
