| |
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, 2006 06:23:09 |
#2 |
| Mainak Aich |
Member Since: Visitor Total Comments: N/A |
RE: What is difference between Rename and Alias?...
|
| If we rename a column or a table it is parmanent but alias is not permanent.Each time we have to specify the alias. |
| |
Back To Question | |
