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 vote290 views1 answer
Psql filed name alter
SQL
0 vote275 views1 answer
Sql value exists in column
SQL
0 vote318 views1 answer
Sql server phone constraint
SQL
0 vote265 views1 answer
Get employees if not contains in sql
SQL
7 votes302 views4 answers
Index in mysql
SQL
0 vote304 views1 answer
Alter domain sql
SQL
0 vote277 views1 answer
Group by sql not ordering issues
SQL
4 votes279 views1 answer
Wildcard in sql
SQL
0 vote301 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote288 views1 answer
Datagrip execute procedure
SQL