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

49 votes250 views6 answers
Install mysql ubuntu
SQL
11 votes229 views3 answers
Pl sql example
SQL
0 vote222 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote216 views2 answers
Get all index postgres
SQL
9 votes248 views3 answers
Sql delete where in
SQL
11 votes281 views2 answers
Import mysql dump command line windows
SQL
0 vote230 views1 answer
SQL Server date literal
SQL
14 votes245 views2 answers
Oracle limit rows
SQL
3 votes229 views1 answer
Postgres count distinct
SQL
2 votes208 views1 answer
Oracle cpu per session
SQL