/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 vote191 views1 answer
How to run mysql on terminal mac
SQL
0 vote182 views1 answer
Drop view in mysql
SQL
0 vote175 views1 answer
Mysql trim characters
SQL
1 vote173 views1 answer
Adding a default constraint to an existing column in sql
SQL
10 votes185 views2 answers
Forgot my mysql password mac
SQL
0 vote163 views1 answer
Search In the Database using Text
SQL
0 vote179 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote202 views1 answer
Java spring boot connect to sql server
SQL
0 vote184 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote166 views1 answer
User privileges postgresql information_schema
SQL