/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 vote383 views2 answers
Mysql missin expression near on
SQL
0 vote416 views1 answer
Query for backup a database at another location in file system
SQL
0 vote380 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote398 views1 answer
How to compile a function in oracle
SQL
3 votes394 views1 answer
Laravel paginate raw sql
SQL
0 vote406 views1 answer
Insert using condition postgres
SQL
1 vote355 views1 answer
Delete specific row in sql
SQL
0 vote367 views1 answer
How to define a non primary composite key in sql
SQL
4 votes418 views1 answer
Mysql store ip address
SQL
0 vote348 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL