/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 vote271 views1 answer
Openquery insert into linked server
SQL
-1 vote301 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote281 views1 answer
Query by column for substring sql
SQL
0 vote271 views1 answer
Cast float mysql
SQL
0 vote291 views1 answer
Sql filter rows with condition
SQL
0 vote292 views1 answer
000webhost database values insert
SQL
0 vote303 views1 answer
Change date format in oracle query
SQL
2 votes272 views3 answers
Postgresql reset auto increment
SQL
0 vote265 views4 answers
Mysql select bottom 10 rows
SQL
2 votes277 views2 answers
How to check data type in sql server
SQL