Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Rename and Alias?
- 1 Answers
- 4488 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 |
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
what is main def between plsql/table and array?
What is a Database instance ? Explain?
Can you assign multiple query result rows to a variable?
How oracle handles dead locks?
Is there any function in oracle similar like group_concat of mysql?
How do I connect to oracle?
what is the syntax of ALTER command?
What is bulk collect in oracle?
what is the difference between rollback & commit? can a foreign key has null value?
What is a cluster Key ?
How to create a stored procedure in oracle?
Oracle General 
