Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Rename and Alias?
- 1 Answers
- 4561 Views
- I also Faced
- E-Mail Answers
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 |
What are the database administrators utilities available?
What is a view and how is it different from a table?
What is an Index ? How it is implemented in Oracle Database ?
How to use values from other tables in update statements using oracle?
What is Data Dictionary Cache in Oracle?
Can objects of the same schema reside in different tablespace?
How to compare dates in oracle sql?
what is the difference between first normal form & second normal form?
What is a tns file?
How to create a stored program unit?
How to create a server parameter file?
What would you use to improve performance on an insert statement that places millions of rows into that table?
Oracle General 
