/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 votes147 views1 answer
Pl sql escape &
SQL
12 votes170 views6 answers
Change mysql root password
SQL
1 vote143 views1 answer
User privileges postgresql information_schema
SQL
0 vote98 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
2 votes149 views1 answer
Update trigger
SQL
1 vote167 views1 answer
Select inside insert query
SQL
0 vote163 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote131 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote152 views1 answer
Incorrect string value: mysql
SQL
0 vote155 views1 answer
Sql common columns
SQL