/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 vote293 views2 answers
Oracle list partitioned tables
SQL
-1 vote282 views1 answer
Mysql coalesce
SQL
5 votes303 views1 answer
Get table columns from sql
SQL
1 vote314 views2 answers
Oracle create synonym
SQL
0 vote292 views1 answer
Add computed column to table sql server
SQL
5 votes304 views2 answers
Create function postgresql
SQL
2 votes275 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote304 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
3 votes276 views3 answers
Mysqldump: couldn
SQL
0 vote293 views1 answer
Php get closest location by latitude longitude
SQL