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

9 votes326 views1 answer
Oracle get table schema
SQL
0 vote325 views1 answer
Date diff sql
SQL
0 vote334 views1 answer
Azure sql server check foreign key
SQL
1 vote341 views1 answer
Sysdate in sql
SQL
1 vote444 views1 answer
Aqua Data studio postgresql ssl
SQL
4 votes325 views1 answer
Select nls_date_format
SQL
1 vote328 views1 answer
Mysql Case sum
SQL
3 votes356 views1 answer
Postgresql today - 1 year
SQL
1 vote331 views1 answer
How to find median of a column sql
SQL
1 vote339 views1 answer
Too many connections mysql
SQL