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 vote315 views1 answer
Sql track modification
SQL
4 votes314 views1 answer
Oracle delete last row
SQL
0 vote362 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
1 vote301 views1 answer
SQLSTATE[HY000] [2002]
SQL
5 votes334 views1 answer
How to get all dates in a month in oracle
SQL
0 vote330 views1 answer
Update and keep original value sql
SQL
0 vote322 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
-2 votes348 views1 answer
How-to-remove-mysql-root-password
SQL
1 vote365 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote318 views2 answers
MySQL top percent
SQL