/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 vote190 views1 answer
Liquibase update row
SQL
4 votes159 views1 answer
Mysql biginteger size
SQL
0 vote200 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote156 views1 answer
Return size of tables in mysql
SQL
0 vote138 views1 answer
How to create an SQL save method in ruby
SQL
0 vote141 views2 answers
Mysql set foreign_key_checks=0
SQL
1 vote160 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote178 views1 answer
Multiple like values for single column postgres
SQL
0 vote186 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote181 views1 answer
Which lock mode is not available in sql
SQL