Hi guys,
I have an sql file that i need to run from command line.
in sql file (please note that is small compared to real life sceanrios):
INSERT ALL
into table1 (column1,columnc1) VALUES (1,2)
into table1 (column1,columnc1) VALUES (3,4)
into table1 (column1,columnc1) VALUES (5,6)
into table1 (column1,columnc1) VALUES (7,8)
into table1 (column1,columnc1) VALUES (9,10)
SELECT * FROM DUAL;
COMMIT;
When im trying to pass this from cmd the folloing error will occur:
SP2-0734: unknown command beginning "into table1..." - rest of line ignored.
SP2-0734: unknown command beginning "into table1..." - rest of line ignored.
SP2-0734: unknown command beginning "into table1..." - rest of line ignored.
SP2-0734: unknown command beginning "into table1..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
What I have tried:
Can someone tell me if there is a work around ?
Thanks for your help ! :)