/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

2 votes123 views1 answer
Oracle find constraints referencing a table
SQL
51 votes232 views6 answers
Opera gx
SQL
0 vote137 views1 answer
Create table split string function in sql server
SQL
0 vote163 views1 answer
Sql get latest of 2 datetimes
SQL
1 vote140 views1 answer
Oracle enable job
SQL
3 votes144 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
1 vote139 views1 answer
Postgresql how to show table names
SQL
1 vote452 views1 answer
Mysql event last execution
SQL
1 vote130 views1 answer
Oracle list datafiles in tablespace
SQL
2 votes127 views1 answer
Set boolean flasksql
SQL