/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 vote207 views2 answers
How to take recent row without limit in mysql
SQL
2 votes175 views2 answers
Select multiple tables mysql
SQL
0 vote191 views1 answer
Get id if is not equal in certain table
SQL
-1 vote200 views1 answer
Round up and down sql
SQL
1 vote198 views1 answer
Delete specific row in sql
SQL
9 votes181 views4 answers
Add primary key to existing table sql
SQL
0 vote196 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote194 views1 answer
Sql values not in another table
SQL
0 vote190 views1 answer
Sql common columns
SQL
0 vote186 views1 answer
MySql get primary keys of table
SQL