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

0 vote167 views1 answer
Online sql compiler
SQL
0 vote200 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
2 votes183 views2 answers
Postgresql date at timezone
SQL
0 vote201 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote199 views1 answer
Postgres sql alter table delete row
SQL
0 vote217 views1 answer
Sql use with to get value counts and percentages
SQL
2 votes178 views1 answer
Mysql auto increment jumping
SQL
2 votes209 views2 answers
How to run postgresql in linux
SQL
0 vote265 views1 answer
Regex mongoose
SQL
0 vote224 views1 answer
Sql basic commands
SQL