/SQL/Oracle alter table add column not null

Oracle alter table add column not null

-- 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

Similar codes

0 vote334 views3 answers
Mysql delete if not in another table
SQL
0 vote377 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
2 votes333 views1 answer
Oracle percentage
SQL
0 vote322 views1 answer
Kill thread
SQL
0 vote360 views1 answer
Oracle concat datetime
SQL
0 vote321 views1 answer
Sql server split string and insert into table select
SQL
3 votes291 views1 answer
How to get list of synonyms in oracle
SQL
0 vote354 views1 answer
Nvl2 syntax
SQL
0 vote278 views1 answer
Check if has alpha characters sql
SQL
4 votes344 views6 answers
Sql select statement
SQL