Collections:
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?
✍: FYIcenter.com
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:
SQL> CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE department_id=90; Table created. SQL> ALTER TABLE emp_dept_90 2 ADD (vacation NUMBER DEFAULT 10); Table altered. SQL> SELECT first_name, last_name, vacation 2 FROM emp_dept_90; FIRST_NAME LAST_NAME VACATION -------------------- ------------------------- ---------- Steven King 10 Neena Kochhar 10 Lex De Haan 10
As you can see, the "DEFAULT 10" clause did inserted 10 to all existing data rows.
⇒ Rename a Column in an Existing Table in Oracle
⇐ Add a New Column to an Existing Table in Oracle
2019-05-25, 1826🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...