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 vote168 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote136 views1 answer
Sql count how many times a value appears
SQL
0 vote187 views1 answer
Cast float mysql
SQL
2 votes181 views1 answer
Delete all value query
SQL
1 vote230 views1 answer
Sqlalchemy on delete set null
SQL
0 vote203 views3 answers
Condition in count sql
SQL
0 vote187 views1 answer
Postgresql check total storage
SQL
1 vote191 views1 answer
Select 2 rows in sql
SQL
5 votes186 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote166 views1 answer
Mysql update sequence with order by
SQL