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

17 votes315 views3 answers
Postgresql version command
SQL
2 votes315 views1 answer
Get first 2 letter in sql
SQL
3 votes332 views2 answers
Search text in all sql server stored procedure
SQL
1 vote526 views2 answers
Sql unique rows
SQL
0 vote314 views1 answer
Select 1 from orders
SQL
0 vote319 views1 answer
Db format in quotation
SQL
2 votes343 views3 answers
Sql server reseed identity column
SQL
0 vote317 views2 answers
PostgreSQL having
SQL
0 vote316 views1 answer
Import sql inside hide sql
SQL
0 vote328 views3 answers
Sql query checker
SQL