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 vote338 views1 answer
Partition by sql server
SQL
1 vote317 views1 answer
Sql avg group by
SQL
1 vote326 views1 answer
Sample clause in sql
SQL
0 vote347 views2 answers
How to prevent sql injection in java
SQL
1 vote326 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote309 views1 answer
First mysql
SQL
3 votes424 views1 answer
Oracle cannot access v$session
SQL
0 vote336 views2 answers
How to install mssql on mac
SQL
0 vote332 views1 answer
Assign value to var in SQL
SQL
0 vote352 views1 answer
Hour and minute between two datatime sql
SQL