/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

3 votes343 views2 answers
Mysql user permission database
SQL
0 vote345 views1 answer
SQL authentication error
SQL
0 vote347 views1 answer
Select insert new table sql server
SQL
0 vote344 views1 answer
Sql server create constraint
SQL
2 votes382 views2 answers
Oracle create table if not exists
SQL
0 vote326 views1 answer
Select top 3 sql
SQL
0 vote329 views1 answer
C# datetime to sql server datetime
SQL
0 vote355 views1 answer
Psql generate id in existing database
SQL
0 vote343 views1 answer
What is between keyword used for
SQL
13 votes346 views2 answers
Get tables in database sql
SQL