/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

-1 vote241 views1 answer
Capitole toulouse
SQL
3 votes230 views1 answer
Mssql remove column
SQL
0 vote231 views2 answers
Mysql disable foreign key checks
SQL
0 vote228 views1 answer
MySQL error code 2068
SQL
0 vote254 views1 answer
Display all node label neo4j
SQL
-1 vote251 views1 answer
Mysql select count if contains
SQL
0 vote239 views1 answer
Psql datestyle
SQL
0 vote246 views4 answers
Stored procedure sql
SQL
0 vote255 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote222 views1 answer
Parsing float to int in mysql
SQL