/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

1 vote286 views1 answer
Update from table tsql
SQL
1 vote258 views1 answer
Oracle stop job
SQL
0 vote268 views2 answers
How to set global time_zone in mysql
SQL
0 vote289 views1 answer
Oracle winter time change
SQL
0 vote265 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote263 views1 answer
Postgres data location
SQL
0 vote259 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote280 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote318 views1 answer
Osm2pgsql mac
SQL
4 votes254 views1 answer
Oracle user tables
SQL