Answer Detail: RE: What is difference between Rename and Alias?...

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.

October 10, 2007 01:58:00	#7
purnachand_venu	Member Since: Visitor Total Comments: N/A
RE: What is difference between Rename and Alias?...
alias is temporary name from column/table . we can't participate in any operation using that alias name. where as rename is a new name given for exiting table or column name.. using this name we can participate in any operations. when ever we given rename for table/column the old name is no more in database

Back To Question