SQL:
Insert into tablename (attribute,attribute1) values(1,0),(2,0),(3,0)
ORACLE:
INSERT ALL
INTO tablename (attribute,attribute1) VALUES (1,0)
INTO tablename (attribute,attribute1) VALUES (2,0)
INTO tablename (attribute,attribute1) VALUES (3,0) select count(*) from dual;
Note : In Oracle U can Bulk Insert Maximum 1000 Columns otherwise it cause Exception.
No comments:
Post a Comment