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 |
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
what is a Nested Loop join?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is oracle thin client?
After using set unused can we enable the column again to use? Please give me some answers....
What is the database name in oracle?
What is a cursor and what are the steps need to be taken?
what is the use of ondelete cascade?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What is the use of Control File ?
What is an Index ?
what is the syntax of DELETE command?