/SQL/Oracle add column with default value

Oracle add column with default value

-- ALTER TABLE <table> ADD <column> <type>  <constraint>;
ALTER TABLE members ADD age NUMBER;
ALTER TABLE members ADD birth_date DATE NOT NULL;
ALTER TABLE members ADD registering DATE DEFAULT sysdate;
ALTER TABLE members ADD member_id NUMBER UNIQUE;

Source: oracletutorial.com

Oracle alter table add column default value

alter table DWSODS01.DWT00301_ORD_DTL_OMS add (
COMB_ORD_FLG NUMBER(5,0) default 0 not nulll); 

alter table DWSODS01.DWT00301_ORD_DTL_OMS add (
COMB_ORD_NO NUMBER(12,0) default 0 not null);

Source: community.oracle.com

Similar codes

2 votes127 views1 answer
How to make insert script from table in SQL server
SQL
0 vote127 views1 answer
Check if string is a number sql
SQL
9 votes142 views4 answers
Oracle get table column names
SQL
4 votes121 views1 answer
Sql delete multiple conditions
SQL
16 votes156 views3 answers
Order by sql query
SQL
1 vote126 views1 answer
Python escape mysql
SQL
1 vote135 views1 answer
Psql import backup file for windows
SQL
4 votes142 views3 answers
Mysql get column names from table
SQL
1 vote121 views1 answer
Last 6 months postgresql
SQL
0 vote115 views1 answer
Truncate table sql server foreign key
SQL