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 -> Syntax Help

Syntax Help

From: WebTracer <randy_at_webtracersolutions.com>
Date: 9 Jun 2005 14:04:33 -0700
Message-ID: <1118351073.915133.55600@g14g2000cwa.googlegroups.com> 





I am trying to insert a record into a table.  The text that was given
to me includes the following piece:



'IRIS,IP&OP SLOT,'


Oracle (TOAD specifically) errors on this ... how do I insert the &
into a text field?  I know there are ways in VB, VBA and C++ to force
this to go in ... but I can't remember how to do it in SQL.



TIA


Randy
Received on Thu Jun 09 2005 - 16:04:33 CDT












Original text of this message













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