Collections:
Rename an Existing Table in Oracle
How To Rename an Existing Table in Oracle?
✍: 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
⇒ Drop an Existing Table in Oracle
⇐ Create a New Table by Selecting Rows from Another Table in Oracle
2019-06-01, 1655🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...