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 vote277 views1 answer
Sql show table name in result
SQL
1 vote234 views2 answers
Delete auto increment mysql
SQL
0 vote269 views1 answer
Import excel to sql
SQL
3 votes269 views1 answer
Fk in insert mysql
SQL
0 vote261 views1 answer
Nth max in my sql
SQL
1 vote277 views1 answer
Search for replace in mysql
SQL
0 vote273 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote262 views1 answer
Output table plsql
SQL
0 vote276 views1 answer
Sql output select
SQL
0 vote272 views1 answer
Drop index in sql
SQL