Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How do I execute this statement in a file?

How do I execute this statement in a file?

From: <laredotornado_at_zipmail.com>
Date: 10 Feb 2006 12:39:24 -0800
Message-ID: <1139603964.751018.44340@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US