/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 vote281 views1 answer
Sql max min
SQL
-1 vote310 views1 answer
Select first rows postgresql
SQL
0 vote326 views1 answer
Space not removing from column in sql
SQL
1 vote330 views1 answer
Nvl postgres
SQL
14 votes301 views2 answers
Oracle export trigger ddl
SQL
16 votes304 views4 answers
Ascending order mysql
SQL
0 vote305 views1 answer
Group by two columns postgres
SQL
1 vote299 views1 answer
How to change owner in postgres
SQL
11 votes274 views2 answers
Sql between date range
SQL
13 votes488 views4 answers
Sql joining 3 tables
SQL