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 vote285 views3 answers
Insert or ignore postgres
SQL
1 vote167 views1 answer
Setval pgsql
SQL
16 votes180 views3 answers
Jwt secret key generator laravel
SQL
2 votes173 views1 answer
Mysql select random id from table
SQL
0 vote258 views1 answer
Python mysql check if database exists
SQL
0 vote175 views1 answer
Postgresql default value boolean
SQL
0 vote185 views1 answer
TSQL convert csv to table
SQL
0 vote174 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
11 votes180 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote195 views1 answer
Split first name and last name in sql
SQL