Saturday, 20 June 2015

Add multiple column in existing oracle table


SYNTAX

ALTER TABLE TABLE_NAME
  ADD (COLUMN_1 DATA_TYPE,
       COLUMN_2 DATA_TYPE,
       ...
       COLUMN_N DATA_TYPE);

e.g.

ALTER TABLE EMPLOYEE_DETAIL
  ADD (EMPLOYEE_FIRST_NAME VARCHAR2(100),
       EMPLOYEE_LAST_NAME VARCHAR2(100));

No comments:

Post a Comment