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, 5153👍, 0💬
Popular Posts:
How can I use tables to structure forms Small forms are sometimes placed within a TD element within ...
Which are the various programming approaches for WCF?
What's the output of the following program? And why? #include main() { typedef union { int a; char b...
What is NullPointerException and how to handle it? When an object is not initialized, the default va...
If client side validation is enabled in your Web page, does that mean server side code is not run? W...