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

7 votes179 views1 answer
Sql management studio display line numbers
SQL
0 vote185 views1 answer
Primary key multiple colums
SQL
0 vote219 views1 answer
Insert output identity
SQL
0 vote181 views1 answer
How to order result of subquery in select
SQL
0 vote174 views1 answer
Order by monthly in sql
SQL
1 vote188 views1 answer
Mysql change root mysql_native_password
SQL
0 vote209 views1 answer
Sql query use select name inside where clause
SQL
0 vote176 views1 answer
Change default schema sql server
SQL
0 vote228 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
1 vote181 views1 answer
Access the postgres psql
SQL