/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

6 votes107 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote103 views1 answer
Mariadb current date plus 1 day
SQL
11 votes97 views3 answers
Sql_mode=only_full_group_by
SQL
1 vote138 views1 answer
Oracle transaction rollback not working
SQL
1 vote102 views2 answers
Difference between in and between in sql
SQL
23 votes107 views4 answers
How to show all users in mysql
SQL
3 votes101 views1 answer
Oracle rollback
SQL
0 vote108 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote93 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
9 votes100 views3 answers
Show table columns mysql command line
SQL