/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 vote288 views1 answer
Sql delete from with relation
SQL
0 vote268 views1 answer
Date diff sql
SQL
0 vote288 views1 answer
How to retrive the today date sql
SQL
0 vote313 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
8 votes307 views4 answers
Reset SQL auto increment
SQL
3 votes318 views6 answers
DB::table('users')->get();
SQL
1 vote271 views1 answer
Oracle rolling back transactions
SQL
-1 vote292 views3 answers
How to restart mysql in linux
SQL
0 vote245 views1 answer
Big query add table rows to another table
SQL
0 vote263 views1 answer
How to check which sp is running in sql server
SQL