/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 vote354 views1 answer
Mysql dump with table query
SQL
0 vote319 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote331 views1 answer
Executescalar in sql server
SQL
0 vote336 views2 answers
How to get the date from datetime in mysql
SQL
9 votes377 views3 answers
Sql delete where in
SQL
0 vote316 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote345 views1 answer
Mysql multiple group by
SQL
0 vote330 views2 answers
Mysql unique two columns
SQL
1 vote348 views1 answer
How to use db.execute
SQL
-1 vote322 views1 answer
Sql set max value in column
SQL