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

1 vote299 views2 answers
Pl sql case
SQL
6 votes315 views2 answers
Clear a table in mysql
SQL
0 vote309 views1 answer
Oracle allow space to user
SQL
0 vote319 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote303 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
41 votes411 views6 answers
Alter table add column in SQL Server
SQL
0 vote303 views2 answers
Mysql output csv
SQL
0 vote313 views1 answer
Rollback to name in sql
SQL
2 votes322 views2 answers
Created at and updated at in mysql
SQL
6 votes297 views1 answer
Rank function in oracle with example
SQL