/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

14 votes116 views1 answer
Excel is not a database
SQL
1 vote140 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
6 votes117 views2 answers
Mysql execute file
SQL
0 vote113 views1 answer
Oracle current session details
SQL
0 vote123 views1 answer
Postgresql concat string with separator
SQL
0 vote116 views1 answer
Criteria builder select subset of column
SQL
8 votes128 views2 answers
Replace string value in sql
SQL
0 vote117 views1 answer
Drop all data from tables
SQL
0 vote114 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote127 views1 answer
Mariadb change column type
SQL