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, 1751🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...