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 vote146 views1 answer
Postgresql inheritance
SQL
5 votes152 views3 answers
Show indexes mysql
SQL
3 votes132 views1 answer
Sql double index
SQL
0 vote142 views1 answer
Psql check table fields
SQL
0 vote133 views1 answer
Rename view mysql
SQL
1 vote152 views1 answer
Get current date in pyspark sql
SQL
1 vote119 views1 answer
Can we drop a primary key
SQL
1 vote118 views1 answer
Oracle lock user
SQL
10 votes140 views1 answer
Oracle dependencies table
SQL
2 votes134 views1 answer
Pdo mysql insert
SQL