Collections:
ALTER TABLE - Add a New Column in Oracle
How To Add a New Column to an Existing Table in Oracle?
✍: FYIcenter.com
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.
⇒ ALTER TABLE - Delete a Column in Oracle
⇐ Create a New Table with SELECT Statements in Oracle
2020-02-29, 1814🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...