/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

58 votes552 views6 answers
Create new user in postgres
SQL
3 votes194 views1 answer
Sql is not like
SQL
0 vote197 views1 answer
How to select only id where is not in column mysql
SQL
0 vote220 views1 answer
Mysql best varchar length size
SQL
0 vote190 views1 answer
To change the database owner in SQL server
SQL
0 vote196 views2 answers
Get all index postgres
SQL
0 vote246 views1 answer
Alternative for LIMIT sql
SQL
2 votes198 views1 answer
Oracle index size
SQL
0 vote231 views1 answer
Postgres full text search example
SQL
0 vote200 views1 answer
Select odd records sql
SQL