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.

February 02, 2006 05:31:33	#1
pavan	Member Since: Visitor Total Comments: N/A
RE: What is difference between Rename and Alias?...
rename is used to change name of the table/column. once we rename the table/column, old column/table name is replaced by new column/table name. alias is the alternate name of the table/column.

Back To Question