January 22nd, 2004, 12:18 PM
insert statement problem IMPORTANT
trying to put a long list of insert statements into the editor.
basically a long list of this:
INSERT INTO budget VALUES (2004,01,'G21501340',001,'Subcontracting',734003,74081);
INSERT INTO budget VALUES (2004,01,'G21501340',002,'Subcontracting',734004,19483);
if i put the semi-colons i get error "invalid character"
if i take them off i get error "SQL command not properly ended"
i know this is probably a simple thing.
what is the proper syntax ?
January 22nd, 2004, 02:19 PM
The syntax is correct , but the problem is how r you running it. Run it as follows:
For example your script name is test.sql.
it will work
January 22nd, 2004, 02:35 PM
First you save it as .sql file by using the follwoing command:
SQL>save test.sql repl
Then use any one from these command: