/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

0 vote307 views1 answer
Sql include rows with 0 values
SQL
2 votes328 views3 answers
Sql function
SQL
0 vote313 views1 answer
Open postgresql.conf in centos
SQL
4 votes276 views1 answer
Mac install mysql
SQL
0 vote387 views1 answer
Sqlite display headers on columns
SQL
6 votes309 views2 answers
Drop foreign key
SQL
0 vote314 views1 answer
Sql drop procedure if exists
SQL
1 vote296 views1 answer
Sql exclude duplicates and find even id
SQL
1 vote360 views1 answer
Best configuration for display table in sqlplus
SQL
8 votes318 views1 answer
How to check mysql version in xampp
SQL