/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

1 vote295 views1 answer
Insert column after column mysql
SQL
0 vote194 views1 answer
Odd record sql query
SQL
0 vote203 views1 answer
Selecting duplicates
SQL
0 vote207 views1 answer
Oracle list partitions
SQL
0 vote221 views1 answer
Sql query use select name inside where clause
SQL
0 vote292 views1 answer
Run mysql xampp shell
SQL
-1 vote208 views1 answer
How to open blade file from blade in laravel
SQL
2 votes192 views1 answer
Oracle calculated column
SQL
4 votes204 views1 answer
Mac install mysql
SQL
-1 vote194 views2 answers
Get day in sql
SQL