/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 vote107 views1 answer
Sql min
SQL
0 vote107 views1 answer
Sql convert datetime to year
SQL
9 votes115 views4 answers
Mysql set id auto increment
SQL
3 votes117 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
1 vote116 views1 answer
Set autoincrement to 0
SQL
2 votes107 views2 answers
Mysql get time from datetime
SQL
0 vote117 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote111 views1 answer
Mysql count grouped rows
SQL
1 vote105 views1 answer
Create sample data postgresql
SQL
1 vote116 views3 answers
Sql union
SQL