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

3 votes372 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
4 votes187 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote279 views1 answer
Oracle create package specification
SQL
0 vote199 views1 answer
Ms sql filter all sympbol
SQL
1 vote213 views1 answer
Update mysql centos
SQL
1 vote193 views3 answers
Mysql disable foreign keys check
SQL
0 vote210 views1 answer
How to join result table in mysql
SQL
1 vote238 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote197 views1 answer
How to declare variable date in mysql
SQL
1 vote197 views1 answer
Oracle sql average
SQL