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

3 votes147 views1 answer
Increment integer in table sql
SQL
0 vote133 views1 answer
PSQL qith variables
SQL
0 vote166 views1 answer
Mysql select random rows large table
SQL
0 vote128 views1 answer
Create a table from one field of another table
SQL
2 votes150 views1 answer
Column names in oracle sql
SQL
3 votes150 views2 answers
Mysql select database
SQL
0 vote132 views5 answers
Linq cheat sheet
SQL
0 vote131 views1 answer
Groupby error in mysql
SQL
2 votes169 views1 answer
Mysql now format
SQL
1 vote132 views1 answer
Adding a default constraint to an existing column in sql
SQL