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

5 votes122 views1 answer
Oracle ORA-00054 origin
SQL
1 vote227 views1 answer
Mysql data from file
SQL
21 votes128 views6 answers
Docker run mysql
SQL
0 vote113 views1 answer
List MySQL Table and Index Size
SQL
0 vote132 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
4 votes128 views1 answer
Postgres delete last row
SQL
0 vote126 views1 answer
Google sheets filter rows above current cell
SQL
0 vote117 views1 answer
Find largest table in mysql database
SQL
22 votes128 views4 answers
Mysql reset auto increment id
SQL
0 vote131 views1 answer
TSQL function split string
SQL