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 vote219 views1 answer
Mysql show current queries
SQL
0 vote243 views1 answer
Sql order by except one row
SQL
2 votes236 views2 answers
Install postgresql
SQL
1 vote257 views1 answer
Insert many to many sql
SQL
0 vote225 views1 answer
Import sql dump into postgresql database
SQL
3 votes231 views2 answers
How to start postgresql on windows
SQL
8 votes262 views4 answers
Reset SQL auto increment
SQL
0 vote244 views1 answer
Query builder doctrien return sql
SQL
0 vote245 views3 answers
Duplicate row mysql
SQL
0 vote221 views1 answer
Select top 3 sql
SQL