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 -> Re: How do I execute this statement in a file?

Re: How do I execute this statement in a file?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 10 Feb 2006 22:24:18 +0100
Message-ID: <43ed0483$0$17059$626a54ce@news.free.fr>

<laredotornado_at_zipmail.com> a écrit dans le message de news: 1139603964.751018.44340_at_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
|

set define off

Regards
Michel Cadot Received on Fri Feb 10 2006 - 15:24:18 CST

Original text of this message

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