OraFAQ Forum: SQL & PL/SQL » & used input values

Home » SQL & PL/SQL » SQL & PL/SQL » & used input values (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

& used input values [message #393931]

Wed, 25 March 2009 00:55

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>');

Report message to a moderator