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, 4894👍, 0💬
Popular Posts:
How To Enter Numeric Values as HEX Numbers? - MySQL FAQs - Introduction to SQL Basics If you want to...
Write out a function that prints out all the permutations of a string. For example, abc would give y...
What are the different elements in Functions points? The different elements in function points are a...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
Can you explain the fundamentals of “GetGlobalResourceObject ”and “GetLocalResourceObject” function...