/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 vote139 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote128 views1 answer
Do postgresql
SQL
0 vote129 views1 answer
Sql contains numeric characters
SQL
2 votes150 views1 answer
Mysql select true or false
SQL
-1 vote163 views2 answers
Sql truncate number
SQL
3 votes130 views1 answer
Oracle sleep
SQL
0 vote130 views1 answer
1 column values in to 1 single row in sql
SQL
6 votes213 views2 answers
Database url postgres
SQL
5 votes156 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
1 vote138 views2 answers
Rebuild index sql server
SQL