.
(Move to ...)
HOME
MSSQL
MYSQL
ORACLE
TERADATA
GREENPLUM
DB2
MARIADB
MONGODB
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
‹
›
Home
View web version
No comments:
Post a Comment