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 vote194 views1 answer
Local pg_sql to heroku pg_sql
SQL
20 votes168 views2 answers
Mysql bigint max value
SQL
0 vote230 views1 answer
Bash block size ls /var/lib/mysql
SQL
2 votes179 views1 answer
Sql string_agg
SQL
6 votes178 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote232 views1 answer
Get enginge db mysql
SQL
2 votes184 views1 answer
Use cases condition in sql query laravel
SQL
1 vote181 views1 answer
Oracle insert multiple rows into same table
SQL
2 votes200 views4 answers
Mysql select into new table
SQL
0 vote172 views2 answers
Create sequence if not exists postgres
SQL