/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 vote160 views1 answer
Leftjoin in sql
SQL
1 vote152 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote148 views1 answer
Nosql vs sql
SQL
0 vote158 views1 answer
Sqlite3 not commit
SQL
0 vote162 views1 answer
Drop all data from tables
SQL
0 vote141 views1 answer
Mysql query to add hours to column in table
SQL
2 votes134 views1 answer
Convert series number to date in sql
SQL
0 vote136 views1 answer
MySQL INSERT IGNORE Statement
SQL
1 vote146 views1 answer
Mysql add fields
SQL
0 vote149 views1 answer
T sql check active deadlock
SQL