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 |
How to join two tables in a single query using oracle?
How to test null values?
What is a OUTER JOIN?
How will you identify oracle database software release?
25. Display the client number and the value of the highest value order placed by that client.
How to create a stored program unit?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
how to find out second largest value in the table
Explain the difference between sap and oracle?
Can group functions be used in the order by clause in oracle?
how to we delete a row using varray
Explain the importance of .pll extension in oracle?