/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 vote186 views4 answers
Sql rownum
SQL
1 vote169 views1 answer
Mysql select month and year
SQL
0 vote179 views1 answer
Drop a field in psql django
SQL
0 vote174 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
5 votes177 views1 answer
Sql add column after another
SQL
0 vote169 views1 answer
Sql view index
SQL
0 vote210 views1 answer
How to insert same table data using mysql query
SQL
1 vote176 views1 answer
Not exists mysql
SQL
0 vote215 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote189 views1 answer
Copied text from internet not inserting in mysql
SQL