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 vote189 views1 answer
Psql store procedure-return multiple table values
SQL
3 votes170 views2 answers
Oracle apex charging debug
SQL
0 vote173 views2 answers
Sql query in dax power bi
SQL
11 votes175 views3 answers
Python sqlite3 create table if not exists
SQL
2 votes169 views1 answer
Delete all value query
SQL
0 vote229 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
5 votes170 views3 answers
Mysql extract month from date
SQL
0 vote164 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
1 vote168 views1 answer
Sometimes i cant edit sql developer
SQL
-1 vote168 views1 answer
Sql oracle take only last results
SQL