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 vote141 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
6 votes115 views2 answers
Mysql version check cmd
SQL
4 votes117 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote117 views1 answer
Azure sql server check foreign key
SQL
0 vote78 views1 answer
Now() -1 mysql
SQL
1 vote124 views1 answer
Mysql count all table rows
SQL
1 vote118 views1 answer
Sql delete row with auto increment
SQL
0 vote112 views1 answer
Dnsmasq.conf location macos
SQL
0 vote136 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote105 views1 answer
Get records in sql according to month name and count
SQL