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 vote205 views1 answer
With_for_update sqlalchemy
SQL
0 vote194 views1 answer
Create boolean column in MySQL with false as default value?
SQL
10 votes229 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote200 views1 answer
Check psql validity function
SQL
7 votes197 views4 answers
Lowest salary in sql
SQL
3 votes201 views5 answers
Mysql get last inserted id
SQL
5 votes200 views6 answers
Sql add days to date
SQL
0 vote256 views1 answer
Oracle temporary table
SQL
0 vote196 views1 answer
Exec procedure oracle
SQL
0 vote209 views1 answer
Mysql join column order By and group By
SQL