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

2 votes267 views3 answers
Xampp mysql database not starting
SQL
57 votes841 views6 answers
Sql alter table
SQL
1 vote192 views1 answer
Oracle apex prevent initial load
SQL
1 vote219 views1 answer
Oracle index partition
SQL
6 votes191 views2 answers
Mysql execute file
SQL
2 votes196 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
1 vote191 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote185 views2 answers
Azure sql-datenbank
SQL
1 vote260 views1 answer
Sql oracle update multiple rows
SQL
0 vote189 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL