Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Rename an Existing Table
How To Rename an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: FYIcenter.com
If you don't like the name of an existing table, you change it by using the CREATE TABLE ... RENAME TO statement. Here is a sample script:
SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees WHERE department_id=10; Table created. SQL> ALTER TABLE emp_dept_10 RENAME TO emp_dept_dba; Table altered. SQL> SELECT first_name, last_name, salary FROM emp_dept_dba; FIRST_NAME LAST_NAME SALARY -------------------- ------------------------- ---------- Jennifer Whalen 4400
2007-05-03, 5741👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - How to prevent my .NET DLL to be decompiled? By design .NET embeds rich M...
How can method defined in multiple base classes with same name be invoked from derived class simulta...
.NET INTERVIEW QUESTIONS - What is Suspend and Resume in Threading ? It is Similar to Sleep and Inte...
How do we create DCOM object in VB6? Using the CreateObject method you can create a DCOM object. You...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.