Oracle add attribute to table

-- 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

Oracle add attribute to table

ALTER TABLE table_name 
ADD column_name data_type constraint;

Similar codes

0 vote274 views1 answer
Modificar tipo de dato sql server
SQL
0 vote180 views1 answer
Oracle index hint
SQL
0 vote187 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote185 views2 answers
Script all indexes in a database
SQL
0 vote259 views1 answer
Migrations.RunSQL
SQL
19 votes192 views3 answers
How to change column type psql
SQL
8 votes191 views1 answer
How to check mysql version in xampp
SQL
1 vote186 views1 answer
Sql run multiple updates in one query
SQL
0 vote189 views1 answer
Multiple left join mysql
SQL
4 votes137 views1 answer
And or sql order of operations
SQL