| |
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. |
| March 03, 2007 12:51:12 |
#4 |
| the_xxx |
Member Since: March 2007 Total Comments: 10 |
RE: What is difference between Rename and Alias?...
|
I would like add one more point.
Rename will change the name of the coulmn/table permanently , where as alias is Query Specific ( name of the coulmn is changed for the query reference). |
| |
Back To Question | |
