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 vote269 views2 answers
Faster mysql imports
SQL
18 votes250 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
37 votes330 views6 answers
Mysql update
SQL
0 vote304 views1 answer
How to find unique element in sql
SQL
0 vote204 views1 answer
Sql count how many times a value appears
SQL
1 vote252 views2 answers
List tables sqlalchemy
SQL
0 vote275 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote268 views1 answer
Datatables server side filter where clause
SQL
2 votes270 views2 answers
Mysql add hours to time field
SQL
0 vote327 views1 answer
Scheduled mysql database backup in linux
SQL