-
-
-
-
-
-
-
-
-
What is difference between Rename and Alias?
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.
-
-
To view installed Oracle version information
Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following: select * from v$version;
-
-