What is difference between Rename and Alias?
Answer / ali
Alias is the temporay name , where as rename is the permanent given.
RENAME:
1. RENAME OLD_TABLENAME to NEW_TABLENAME;
2. alter table table_name rename column column_name to new_columnname;
ALIAS:
1. select ename as name from table_name1 as empl1, table_name2 as empl2 where empl1.id = empl2.id;
| Is This Answer Correct ? | 5 Yes | 0 No |
How to write date and time interval literals in oracle?
How to create a new user account in oracle?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
How would you optimize a slow SQL query?
How to create a stored program unit?
Explain the use of inctype option in exp command.
How do we get field details of a table?
Can we store pictures in the database and if so, how it can be done?
difference between oracle8i and oracle9i
Difference between an implicit & an explicit cursor.?
When do you get a .pll extension in oracle? Explain its importance
What is difference between a formal and an actual parameter?