Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How do I execute this statement in a file?
Hello,
I have a file with one statement
INSERT INTO COPS.PRODUCT_TITLES (ISBN, TITLE) VALUES ('1230512980', ' Lab Activities & Long-Term Projects, AlgOneInter Crs 2');
But when I try and run this (using "start myfile.sql" in sqlplus) I keep getting this message:
Enter value for long:
Is the "&" character screwing things up? How do I change the above statement so that things will be inserted successfully?
Thanks, using Oracle 9i, btw, - Dave Received on Fri Feb 10 2006 - 14:39:24 CST