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, 1849🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...