/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 vote284 views1 answer
Mysql select row max date
SQL
3 votes254 views2 answers
MySQL query to get column names
SQL
7 votes258 views1 answer
Sql limit decimal places
SQL
1 vote248 views1 answer
Select 2 rows in sql
SQL
0 vote228 views1 answer
Metada in sql
SQL
0 vote239 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote272 views1 answer
Avg mysql
SQL
1 vote255 views2 answers
Check if word is in column sql
SQL
0 vote257 views1 answer
Sql select lowest value row
SQL
1 vote241 views1 answer
Mysql random limit 1
SQL