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

0 vote65 views1 answer
Ms sql print more than 1 variable
SQL
0 vote116 views1 answer
Subquery aggregation
SQL
1 vote119 views1 answer
Altrer name column postgres
SQL
0 vote175 views2 answers
Wordpress change url in database
SQL
0 vote108 views1 answer
Netstat -tln mysql
SQL
8 votes128 views1 answer
Database backup in mysql server recovery
SQL
0 vote136 views1 answer
Calculer pourcentage mysql
SQL
4 votes121 views1 answer
Data types in sql
SQL
3 votes126 views5 answers
Sql select
SQL
0 vote125 views1 answer
Oracle synonym procedure dblink
SQL