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 vote262 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote257 views1 answer
Java nosql sort
SQL
0 vote309 views2 answers
Mysql insert rows to another database
SQL
1 vote235 views1 answer
Postgres convert exisiting column to text
SQL
3 votes262 views6 answers
Jwt laravel
SQL
12 votes270 views6 answers
Change mysql root password
SQL
1 vote232 views1 answer
Oracle list constraints
SQL
0 vote228 views1 answer
MySQL error code 2068
SQL
0 vote223 views1 answer
T sql return on letters only
SQL
0 vote226 views1 answer
Php delete database
SQL