/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 vote141 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote108 views1 answer
List mysql tables and views
SQL
9 votes115 views2 answers
Sql limit order by
SQL
0 vote117 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote67 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote118 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote112 views1 answer
Mysql remove tabs from string
SQL
3 votes133 views1 answer
Set default today mysql
SQL
3 votes120 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
3 votes125 views2 answers
Enter mysql command line
SQL