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

1 vote281 views1 answer
Postgres convert exisiting column to text
SQL
0 vote263 views1 answer
How to count null values in sql
SQL
1 vote276 views1 answer
Create temporal table in sql
SQL
1 vote290 views1 answer
Postgresql datetrunc too slow
SQL
0 vote294 views1 answer
Connecting mySQL to STS
SQL
1 vote264 views1 answer
Sql myisam vs innodb
SQL
0 vote272 views1 answer
SQL get max per id
SQL
0 vote275 views1 answer
How to query all tables mysql at the same time
SQL
18 votes264 views4 answers
Foreign key mySql
SQL
1 vote308 views1 answer
Sqlalchemy order by descending
SQL