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 vote331 views3 answers
How to update column name in psql
SQL
1 vote300 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
36 votes316 views6 answers
Rename table sql
SQL
1 vote347 views1 answer
Db.Database.SqlQuery
SQL
7 votes331 views4 answers
Index in mysql
SQL
0 vote313 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote278 views1 answer
Linux upload database to mysql
SQL
1 vote312 views1 answer
Continue in sql
SQL
0 vote313 views1 answer
Mysql select inside sum
SQL
3 votes293 views1 answer
Sql datetime as date
SQL