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

9 votes168 views2 answers
Mysql change value
SQL
-1 vote184 views1 answer
Get month and year from date in mysql sequelize
SQL
2 votes200 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote162 views2 answers
Mysql regexp match word
SQL
0 vote169 views1 answer
St_buffer mysql
SQL
2 votes162 views1 answer
Create table with primary key
SQL
1 vote160 views1 answer
Check message id sql server
SQL
0 vote169 views2 answers
Mysql disable foreign key checks
SQL
1 vote180 views3 answers
How to get date in sql
SQL
0 vote163 views1 answer
Delete double on SQL with multiple primary keys
SQL