/SQL/Oracle alter table add column not null

Oracle alter table add column not null

-- 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

51 votes278 views6 answers
Opera gx
SQL
1 vote171 views3 answers
Union SQL
SQL
1 vote173 views2 answers
Changes not showing on website server odoo
SQL
0 vote176 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote163 views1 answer
Google cloud sql postgres url example
SQL
0 vote126 views1 answer
Java spring boot connect to sql server
SQL
1 vote153 views1 answer
Select random sample sql
SQL
0 vote160 views1 answer
Oracle INTERVAL DAY to second to number
SQL
2 votes174 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote167 views1 answer
Mysql listing get a particu particular user firsdt
SQL