/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 vote187 views1 answer
Base64 encode sql server
SQL
8 votes193 views3 answers
Postgres database sizes
SQL
0 vote194 views1 answer
Load data infile mariadb slow
SQL
24 votes167 views5 answers
Sql reset auto increment
SQL
0 vote177 views1 answer
Oserror mysql_config not found virtualenv
SQL
3 votes186 views3 answers
Mysql order by list
SQL
0 vote175 views1 answer
Query to get all primary keys and foreign key
SQL
4 votes194 views3 answers
Postgres set default value
SQL
0 vote196 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote184 views1 answer
Postegresql update to null
SQL