Oracle alter table add column

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

ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;

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

1 vote135 views1 answer
Mysql show queries running
SQL
6 votes140 views1 answer
Oracle rank
SQL
0 vote174 views1 answer
Contraint default SQL
SQL
0 vote139 views2 answers
Plsql function that return a table
SQL
6 votes139 views2 answers
Insert into select mysql
SQL
1 vote119 views1 answer
Use of now() in mysql
SQL
2 votes171 views1 answer
Creating a view SQL
SQL
1 vote121 views1 answer
Oracle truncate partition
SQL
0 vote126 views1 answer
Select other columns with distinct
SQL
0 vote154 views2 answers
Nested query
SQL