Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I execute this statement in a file?
<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