/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

4 votes227 views1 answer
What are the data types in sql
SQL
0 vote217 views1 answer
Sql query for displaying age from oldest to youngest
SQL
4 votes212 views1 answer
SQL order random
SQL
13 votes227 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote237 views2 answers
Begin transaction in sql
SQL
1 vote244 views2 answers
Backup table mssql
SQL
4 votes215 views1 answer
Mac install mysql
SQL
20 votes223 views4 answers
Sqlite create table if not exists
SQL
0 vote236 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote229 views1 answer
Oracle synonym procedure dblink
SQL