/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 vote131 views2 answers
Sql last updated
SQL
0 vote149 views1 answer
How to get nth number in sql
SQL
18 votes163 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote123 views1 answer
Concat column value of same user in mysql
SQL
0 vote146 views1 answer
Adding generated time in row mysql workbench
SQL
3 votes139 views2 answers
Sqlite print all column names
SQL
0 vote140 views1 answer
Insert ip address in mysql
SQL
0 vote140 views1 answer
Power bi union columns
SQL
1 vote158 views1 answer
Sql list all procedures
SQL
1 vote156 views1 answer
Opensuse restart MySQL
SQL