/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 vote351 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
3 votes424 views2 answers
See mysql users ubuntu
SQL
0 vote375 views1 answer
Systems sql
SQL
0 vote355 views1 answer
Output table plsql
SQL
14 votes380 views3 answers
Inner join sql oracle
SQL
4 votes367 views2 answers
Oracle unlock user
SQL
0 vote366 views1 answer
How to read the potentail error messages in ssis package
SQL
9 votes358 views2 answers
Sql limit order by
SQL
3 votes323 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote485 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL