/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 vote138 views2 answers
Homebrew nysql launch
SQL
0 vote150 views1 answer
What is between keyword used for
SQL
0 vote189 views1 answer
Modificar tipo de dato sql server
SQL
2 votes161 views1 answer
Oracle apex who is connected
SQL
4 votes156 views1 answer
Conda install sqlalchemy
SQL
1 vote175 views1 answer
Oracle schema size
SQL
0 vote162 views2 answers
Mysql dump structure only
SQL
0 vote164 views1 answer
Python sqlalchemy connection show server
SQL
2 votes138 views2 answers
Mysql all columns
SQL
0 vote138 views1 answer
Table or view does not exist
SQL