/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 vote224 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote243 views2 answers
How covert into int in maria db
SQL
0 vote237 views1 answer
Sql show all users
SQL
0 vote234 views2 answers
Sql join on wildcard
SQL
0 vote252 views2 answers
Mysql two column combination unique
SQL
1 vote235 views1 answer
Oracle list data files
SQL
1 vote245 views1 answer
Adding a check statement in sql
SQL
0 vote226 views1 answer
Sql count null as 0
SQL
8 votes233 views3 answers
Postgresql connection string c#
SQL
1 vote247 views1 answer
Regular expression in sql server
SQL