Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Rename and Alias?
- 1 Answers
- 4483 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 |
how to make an oracle object
What is Oracle table?
What is Public Database Link ?
Can you use a commit statement within a database trigger?
What is an oracle user role?
Explain oracle’s system global area (sga).
How to start a specific oracle instance?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
How data locks are respected in oracle?
What is archive log in Oracle?
What's dateware house and what's clustor with practicle example
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
Oracle General 
