/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

23 votes361 views2 answers
Query to delete a database in mysql
SQL
0 vote345 views1 answer
Addition of 2 column value in mysql
SQL
5 votes352 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote348 views1 answer
Postgresql regular expression special characters
SQL
0 vote362 views1 answer
How much space does sql server take per row
SQL
0 vote352 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote334 views1 answer
What are the aggregate function in sql
SQL
1 vote354 views1 answer
Sql select contem uma palavra
SQL
0 vote443 views1 answer
Compress sql file database ubuntu
SQL
0 vote354 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL