Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

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

Please provide your feedback in the comments section above. Please don't forget to follow.