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

1 vote206 views1 answer
Return size of tables in mysql
SQL
1 vote224 views1 answer
Mysql Case sum
SQL
58 votes566 views6 answers
Create new user in postgres
SQL
1 vote212 views1 answer
Mysql limit results to 10
SQL
1 vote197 views3 answers
How to filter repeated same result using sql query
SQL
-1 vote212 views1 answer
Count occurrences sql
SQL
3 votes197 views1 answer
Two selects in one query
SQL
0 vote238 views1 answer
Virtuoso sql query tutorial
SQL
0 vote221 views1 answer
Renommer base sql
SQL
0 vote219 views1 answer
What logs are available on RDS MySQL?
SQL