/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

12 votes309 views2 answers
Delete all data in neo4j
SQL
1 vote274 views1 answer
Into sql
SQL
0 vote356 views1 answer
Add super privilege mysql
SQL
0 vote345 views1 answer
Error code 1241 mysql
SQL
0 vote327 views1 answer
How to order result of subquery in select
SQL
0 vote335 views1 answer
Adding generated time in row mysql workbench
SQL
1 vote305 views2 answers
How to drop a unique constraint in sql
SQL
0 vote321 views1 answer
Mysql use password error
SQL
9 votes311 views3 answers
Sequence postgresql
SQL
0 vote310 views2 answers
Mysql multiply
SQL