Oracle - Add a New Column to an Existing Table in Oracle

Add a New Column to an Existing Table in Oracle

Q

How To Add a New Column to an Existing Table in Oracle?

✍: FYIcenter.com

A

If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script:

SQL> connect HR/fyicenter
Connected.

SQL> CREATE TABLE emp_dept_110 
  2  AS SELECT * FROM employees WHERE department_id=110;
Table created.

SQL> ALTER TABLE emp_dept_110 ADD (vacation NUMBER);
Table altered.

SQL> SELECT first_name, last_name, vacation
  2  FROM emp_dept_110;
FIRST_NAME           LAST_NAME                   VACATION
-------------------- ------------------------- ----------
Shelley              Higgins
William              Gietz

This SQL script added a new column called "vacation" to the "emp_dept_110" table. NULL values were added to this column on all existing data rows.

⇒Managing Oracle Database Tables

⇒⇒Oracle Database Tutorials

2019-05-25, 610👍, 0💬

Add a New Column to an Existing Table with a Default Value in Oracle
How To Add a New Column to an Existing Table with a Default Value in Oracle? If you want to add a new column to an existing table, and insert a default value in this column on all existing data rows, you can use the ALTER TABLE ... ADD statement with the DEFAULT clause. Here is an example script: SQ... 2019-05-25, 609👍, 0💬

Rename an Existing Table in Oracle
How To Rename an Existing Table in Oracle? 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 de... 2019-06-01, 580👍, 0💬

Rename a Column in an Existing Table in Oracle
How To Rename a Column in an Existing Table in Oracle? Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statement to do this. See the following SQL scr... 2019-05-25, 546👍, 0💬

Drop an Existing Table in Oracle
How To Drop an Existing Table in Oracle? If you want to delete an existing table and its data rows, you can use the DROP TABLE statement as shown in this script: SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees WHERE department_id=10; Tabl... 2019-05-25, 542👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.