Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Rename and Alias?
- 1 Answers
- 4420 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 |
Give the various exception types.
Please explain oracle left join with an example?
What is a data dictionary and how can it be created?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is a cursor and what are the steps need to be taken?
Give the advantages and disadvantages of clusters.
What is a Public Synonyms ?
How to write date and time interval literals in oracle?
how to get the index id?
Display Odd/ Even number of records?
What are the Characteristics of Data Files ?
if you ctreate table identity
Oracle General 
