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 vote121 views1 answer
How to create a new shema using query languaage
SQL
0 vote107 views1 answer
Update using case in mysql
SQL
22 votes124 views3 answers
Remove all records from table mysql
SQL
0 vote109 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote107 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote120 views2 answers
Update query with between in mysql
SQL
10 votes141 views6 answers
Mysql set root password
SQL
1 vote115 views1 answer
Store select query result in variable sql server
SQL
15 votes119 views2 answers
Select Options
SQL
0 vote166 views1 answer
ORA-01400
SQL