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 vote227 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
-1 vote211 views1 answer
Capitole toulouse
SQL
0 vote202 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote164 views1 answer
Plsql trigger insert update
SQL
0 vote235 views2 answers
Impala rename column name
SQL
1 vote210 views1 answer
Oracle sql create view
SQL
1 vote212 views2 answers
Postgresql remote connect
SQL
0 vote226 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote209 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote228 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL