Oracle new column

-- 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 vote281 views1 answer
Do you know sql
SQL
0 vote170 views2 answers
Android sqlite query join
SQL
19 votes196 views6 answers
What is mySQL
SQL
-1 vote182 views1 answer
Mysql case when multiple conditions
SQL
0 vote187 views2 answers
Sql use not in
SQL
0 vote207 views1 answer
How to select even id in sql
SQL
0 vote208 views1 answer
Hierarchal database table
SQL
0 vote198 views1 answer
Mysql server not running
SQL
0 vote182 views1 answer
Postgresql find missing id
SQL
1 vote191 views1 answer
Oracle finding duplicate records
SQL