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 vote588 views1 answer
The differnece between to values in sql
SQL
0 vote353 views1 answer
Except in sql
SQL
0 vote443 views1 answer
Mysql show schema
SQL
3 votes377 views3 answers
Create a view postgres
SQL
2 votes400 views2 answers
Mysql does sentence contain word
SQL
1 vote371 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
5 votes370 views1 answer
Oracle sysdate - 1 month
SQL
19 votes374 views5 answers
Date between in mysql
SQL
4 votes374 views1 answer
Id increment ms sql server
SQL
1 vote344 views2 answers
Pl sql case
SQL