/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 vote302 views2 answers
Create row number in sql
SQL
1 vote292 views2 answers
Mysql between
SQL
0 vote282 views1 answer
Get record which is available in one table but not in another mysql
SQL
7 votes329 views2 answers
Sql remove duplicates based on column
SQL
0 vote291 views1 answer
Postgres set default schema
SQL
2 votes298 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote288 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote265 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
4 votes285 views2 answers
Oracle sql group by date year
SQL
0 vote292 views1 answer
Mysql range of dates overlap
SQL