| |
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, 2006 04:51:51 |
#3 |
| nitin |
Member Since: Visitor Total Comments: N/A |
RE: What is difference between Rename and Alias?...
|
the difference is that rename is used to change the name of the column or table!
alias it is a name given to table which is used as an object extracting the information from the table and gives more meaning to query implemented!
it is just like an object.variable which we use in OOP's concept!
|
| |
Back To Question | |
