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 |
Explain what are clusters?
What is self-referential integrity constraint ?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What do you understand by a database object?
How to assign data of the deleted row to variables?
How to define a variable to match a table column data type?
How are extents allocated to a segment?
What is a cluster Key ?
What are the execution control statements in oracle?
What is the use of oracle?
Which is better Oracle or MS SQL? Why?
How to delete all rows a table in oracle?