/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 vote370 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
5 votes333 views2 answers
Oracle list columns schema
SQL
0 vote349 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote344 views1 answer
What alter does in db
SQL
0 vote347 views2 answers
Default constraint in ms sql
SQL
0 vote321 views1 answer
Cara menampilkan user di mysql terminal
SQL
1 vote332 views1 answer
Postgresql delete cascade
SQL
0 vote345 views3 answers
Duplicate row mysql
SQL
-2 votes325 views1 answer
Modify column name in tsql
SQL
2 votes338 views1 answer
Mysql last 7 days including today
SQL