Home » SQL & PL/SQL » SQL & PL/SQL » & used input values (oracle 10g)
& used input values [message #393931] Wed, 25 March 2009 00:55 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I want to insert into one table.
But it asks for the *nbsp, oslash, aring* values.

Because in the values caluase there are *&nbsp, &oslash, &aring*
How can i suppress those values?
Actually i have SQL script in which there are 2000 insert sql's and it always asks which i run this script from TOAD
Thanks,
INSERT INTO "TEST"."BATCHLINE"("ID","BATCH_ID","SYSCHANGEDBY","SYSCREATED","SYSCHANGED","SYSCREATEDBY","TXT") VALUES ('55743331','305747510',NULL,TO_DATE('25-MAR-09', 'DD-MON-RR'),NULL,'TEST','Se   vores website for detaljer. </font></td>
            <td width="17" align="left">&nbsp;</td>
          </tr>
        </TABLE></td>
      </tr>
      <tr>
        <td height="20"><hr align="center" width="520" SIZE="1" noshade="noshade" /></td>
      </tr>
      <tr>
        <td height="40" align="center" valign="middle"><font color="#666666" style="font-size:9px; font-family:Arial, Helvetica, sans-serif;">VistaPrint leverer den h&oslash;jeste kvalitet indenfor fuldfarve grafisk design og print til de laveste   priser.<br />
          VistaPrint servicerer  mere END 17.000.000 kunder verden OVER.</font></td>
      </tr>
      <tr>
        <td height="41" align="center" valign="middle"><font color="#666666" style="font-size:9px; font-family:Arial, Helvetica, sans-serif;">Produkter og servicen   beskrevet i denne e- mail er udbudt af VistaPrint LIMITED, den internationale   leder indenfor webtop grafisk design og print.Kunder i De forenede   amerikanske stater kan kontakte os p&aring; vores hovedkontor:<br />
          VistaPrint   USA incoporated, 95 Hayden Avenue, Lexington, MA   02421</font></td>
      </tr>
      <tr>
        <td height="40" align="center" valign="middle"><font color="#666666" style="font-size:9px; font-family:Arial, Helvetica, sans-serif;"> <img src="http://marketing.vistaprint.com/fr/imgs/raf/lock.gif" alt=" " width="30" height="30" hspace="5" align="absmiddle" /> Din information er beskyttet med en 128-SSL kryptering.</font> </td>
      </tr>
    </TABLE></td>
  </tr>
<img src="http://www.googole.com/vp/acqemailspot.aspx?S=2234197761" height=0 width=0 border=0/>
</TABLE>
<p><br />
</p>
</BODY>
</html>');
Re: & used input values [message #393934 is a reply to message #393931] Wed, 25 March 2009 01:20 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TOAD? Something like this?

In SQL*Plus, you'd use SET DEFINE OFF.
Re: & used input values [message #393986 is a reply to message #393931] Wed, 25 March 2009 05:02 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or you could repalce each & with
'||chr(38)||'
Previous Topic: query to procedure
Next Topic: How to spool CLOB Column's data to file?
Goto Forum:
  


Current Time: Fri Dec 02 23:10:00 CST 2016

Total time taken to generate the page: 0.14000 seconds