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

6 votes215 views1 answer
Sqlite foreign key
SQL
0 vote219 views2 answers
How to find max and min salary in sql
SQL
32 votes228 views6 answers
Sql count where
SQL
1 vote239 views1 answer
Update mysql centos
SQL
0 vote235 views1 answer
Get a list of tables and the primary key
SQL
0 vote231 views1 answer
Sql last 3 rows
SQL
7 votes216 views3 answers
How to check table name in current database sql
SQL
0 vote229 views2 answers
Oracle sql for each row
SQL
0 vote256 views1 answer
Get initial in sql
SQL
0 vote233 views1 answer
Best sql collation
SQL