Answer Posted / 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 |
Post New Answer View All Answers
How to convert raw data type into text in oracle? Explain
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is a private synonym?
What are set operators?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to build data dictionary view an new database?
What is a initialization parameter file in oracle?
How to execute a stored program unit?
Is there any function in oracle similar like group_concat of mysql?
How to define a record variable to store a table row?
What is a nvl function? How can it be used?
How can you use check constraints for self referential integrity?
Is there a combination of "like" and "in" in sql?
How to use an explicit cursor without open statements?
How a tablespace is related to data files?