/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

1 vote336 views2 answers
Mysql current user
SQL
7 votes322 views2 answers
Create mysql user
SQL
28 votes399 views6 answers
Sql update
SQL
8 votes348 views1 answer
Oracle add months to sysdate
SQL
1 vote332 views1 answer
T-SQL Alter the column data type
SQL
0 vote330 views1 answer
Oracle select invalid views
SQL
8 votes363 views2 answers
Sqlsrv default port
SQL
0 vote360 views1 answer
Get initials name in sql
SQL
0 vote386 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote309 views1 answer
Big query add table rows to another table
SQL