May 11, 2020 in Oracle
Q:

What is the difference between rename and alias?

1 Answer

0 votes
May 11, 2020

Rename is actually changing the name of an object whereas Alias is giving another name (additional name) to an existing object.

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.

Related questions

0 votes
Jul 12, 2020 in Sql
0 votes
May 13, 2020 in Oracle
...