.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Please provide your feedback in the comments section above. Please don't forget to follow.
No comments:
Post a Comment