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

2 votes193 views1 answer
Mysql select default if null
SQL
2 votes205 views1 answer
Column names in oracle sql
SQL
60 votes551 views6 answers
Add column in sql
SQL
0 vote190 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
3 votes186 views2 answers
How to start postgresql on windows
SQL
1 vote173 views1 answer
Xampp import sql file command line
SQL
1 vote217 views1 answer
Mysql select update same table
SQL
0 vote144 views1 answer
Raven ql select count
SQL
0 vote268 views1 answer
Do you know sql
SQL
0 vote187 views1 answer
Oracle table free space
SQL