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 vote116 views1 answer
Enable sql server full text indexing
SQL
2 votes128 views1 answer
Show max_allowed_packet mysql
SQL
12 votes119 views1 answer
Create column sql server
SQL
2 votes108 views1 answer
Oracle generated column
SQL
1 vote115 views1 answer
Oracle sql create or replace view
SQL
1 vote113 views1 answer
Mysql select from outside
SQL
0 vote108 views1 answer
Mysql replication change database name
SQL
0 vote104 views1 answer
Difference between varchar and varchar2
SQL
23 votes112 views2 answers
Query to delete a database in mysql
SQL
0 vote100 views1 answer
Mysql workbench indent formatting
SQL