/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

25 votes189 views1 answer
Mysql grant all privileges to a user
SQL
0 vote193 views1 answer
Mysql subdate
SQL
0 vote204 views1 answer
Dump db only triggers mysql
SQL
24 votes215 views6 answers
Alter table name sql
SQL
8 votes198 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote209 views1 answer
Plsql find location of procedure
SQL
1 vote197 views1 answer
Add many column to sap iq table
SQL
1 vote195 views1 answer
Import database from a file using mysql commandline
SQL
1 vote203 views1 answer
Postgres start database on linux
SQL
1 vote200 views1 answer
Sql week commencing date
SQL