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

3 votes195 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote292 views1 answer
Column with prefix in sql
SQL
1 vote281 views3 answers
Showing all columns in an sqlite table
SQL
0 vote196 views1 answer
Why mysql is used?
SQL
3 votes202 views1 answer
Oracle apex call duration
SQL
3 votes201 views1 answer
Insert into table from another table mysql
SQL
1 vote203 views1 answer
Name of today sql
SQL
1 vote185 views1 answer
Sql Split string function
SQL
0 vote224 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
2 votes222 views1 answer
Cannot return non-composite value from function that returns composite type
SQL