Oracle new column

-- 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

3 votes367 views1 answer
Locate sql server
SQL
1 vote348 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote388 views1 answer
Acutal month year
SQL
4 votes381 views2 answers
Sqlalchemy_database_uri for mysql
SQL
5 votes340 views1 answer
Mysql change primary key
SQL
0 vote335 views1 answer
Check psql validity function
SQL
0 vote332 views1 answer
Sql remove first character from string
SQL
0 vote329 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
1 vote336 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote350 views1 answer
Sql server select value large text
SQL