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

7 votes299 views1 answer
Xampp reset mysql
SQL
2 votes331 views1 answer
Sql find not in list
SQL
0 vote289 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
3 votes275 views1 answer
Oracle apex message quit website
SQL
2 votes315 views3 answers
Mysql kill
SQL
3 votes303 views1 answer
Sql insert inserted id
SQL
11 votes282 views2 answers
Having in sql
SQL
0 vote275 views1 answer
Mysql command line ubuntu
SQL
0 vote276 views2 answers
MySQL top percent
SQL
1 vote288 views1 answer
Sample clause in sql
SQL