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

4 votes153 views3 answers
Is not null sql
SQL
1 vote133 views2 answers
Sql for date greater than
SQL
0 vote145 views1 answer
Declare or use variable in snowflake
SQL
2 votes133 views1 answer
Get first 3 letters name in sql
SQL
0 vote136 views1 answer
Sql join on a subquery
SQL
0 vote132 views1 answer
SQL server select to get sum of hours
SQL
2 votes136 views2 answers
Get all tables using like
SQL
6 votes184 views2 answers
Install psql mac
SQL
0 vote172 views1 answer
Sql server delete records with specific date
SQL
0 vote132 views1 answer
Sql server select furst day of current year
SQL