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 vote128 views2 answers
Plpgsql
SQL
0 vote101 views1 answer
Postgres can integer fields be negative
SQL
0 vote98 views1 answer
10000000000000000000 am to meters
SQL
0 vote104 views1 answer
Create table Statement Syntax in SQL Server
SQL
3 votes111 views1 answer
How to uninstall microsoft sql server
SQL
0 vote119 views1 answer
Sql log file inof
SQL
1 vote125 views1 answer
Concat first name and last name in mysql
SQL
0 vote101 views1 answer
Sql tablo hangi sp de
SQL
0 vote102 views1 answer
Call rest api from postgresql
SQL
0 vote104 views1 answer
Call object contructor and call methods of object
SQL