/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

0 vote310 views1 answer
Procedures sql insert mysql
SQL
2 votes342 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
1 vote321 views1 answer
Blob datatype in mysql
SQL
0 vote302 views2 answers
Android sqlite tutorial for beginners
SQL
2 votes319 views1 answer
Set username and password for postgresql database
SQL
1 vote304 views1 answer
How to get alternate records from a table in sql
SQL
0 vote282 views1 answer
Mariadb list tables
SQL
0 vote325 views1 answer
Insert overwrite table in mysql in nifi
SQL
3 votes306 views3 answers
Into in sql
SQL
3 votes292 views1 answer
What is having clause
SQL