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

2 votes256 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote269 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote256 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
33 votes271 views6 answers
Change column name in mysql
SQL
1 vote268 views1 answer
Get table column names sql ssms
SQL
0 vote285 views1 answer
Oracle webcenter content search enginer
SQL
1 vote265 views2 answers
How to add amount between date in sql
SQL
10 votes266 views3 answers
Sql check double value
SQL
0 vote258 views1 answer
Pl sql round
SQL
4 votes266 views1 answer
SQL find text in SP
SQL