/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 vote212 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote215 views1 answer
Restart sql server command line linux
SQL
1 vote154 views1 answer
Unique vs distinct sql
SQL
0 vote208 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote227 views1 answer
Move table to a different schema
SQL
0 vote223 views1 answer
Insert value in identity
SQL
0 vote238 views1 answer
Mysql date without time
SQL
0 vote233 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote200 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote205 views1 answer
How to write triggers to increment or decrement the number of employees
SQL