/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

1 vote224 views3 answers
Postgresql crete view
SQL
34 votes227 views6 answers
Sql change data type
SQL
0 vote244 views1 answer
Oracle table privileges
SQL
1 vote244 views1 answer
Quit mysql
SQL
2 votes236 views1 answer
How to get weekday from old date in sql
SQL
0 vote240 views1 answer
Sql decimal to 2 places
SQL
0 vote230 views1 answer
Sql period overlap
SQL
17 votes228 views3 answers
How to change a collumn name in sql
SQL
0 vote259 views2 answers
How to get max from each department in sql
SQL
6 votes223 views2 answers
Join vs union
SQL