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

5 votes198 views1 answer
Get table columns from sql
SQL
0 vote183 views1 answer
Mysql check datetime equals date
SQL
2 votes179 views1 answer
Mysql virtual column
SQL
0 vote282 views1 answer
Restart serial number for postgres
SQL
10 votes235 views4 answers
Join multiple tables in sql
SQL
10 votes191 views4 answers
Drop primary key
SQL
7 votes179 views1 answer
Alter sequence set current value oracle
SQL
0 vote193 views1 answer
Apt install sql server
SQL
0 vote179 views1 answer
Install mysql for fedora 34
SQL
1 vote181 views1 answer
Wordpress change url phpmyadmin
SQL