Oracle add column

-- 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

Alter table oracle

ALTER TABLE tablename MODIFY columnname varchar2(100)

Add column table pl sql

ALTER TABLE table_name
  ADD column_name column_definition;

Oracle alter table add column

ALTER TABLE table_name 
	ADD column_name data_type constraint;

Similar codes

3 votes290 views2 answers
Brew start mysql
SQL
0 vote286 views1 answer
How should I pass a table name into a stored proc?
SQL
3 votes282 views3 answers
Into in sql
SQL
0 vote301 views1 answer
Drop specific row postgresql
SQL
0 vote304 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote269 views1 answer
Oracle sql date summer time
SQL
7 votes367 views2 answers
Drop index oracle
SQL
0 vote298 views1 answer
Sql DATE = GETDATE()
SQL
0 vote288 views2 answers
Sql server select where date
SQL
1 vote302 views3 answers
SELECT * FROM
SQL