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

21 votes287 views1 answer
SQL cheat sheet pdf
SQL
0 vote262 views1 answer
Add sqlite3 in lumen
SQL
10 votes265 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote317 views1 answer
Postgres list all triggers
SQL
5 votes306 views2 answers
Add days in oracle sql
SQL
3 votes267 views1 answer
Mssql remove column
SQL
5 votes259 views1 answer
Oracle asynchronous procedure
SQL
22 votes266 views3 answers
Join three tables sql
SQL
2 votes293 views2 answers
Mysql on duplicate key update get value from values
SQL
1 vote271 views1 answer
Mysql not supported auth mode
SQL