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: Inserting single quotes into database

Re: Inserting single quotes into database

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 12 Mar 1999 18:44:12 +0100
Message-ID: <36e9526e$0$2617@newton> 





sannarayan wrote


>Can anyone please tell me how to insert


>a single quote (" ' ")into an oracle table.





You need to type them twice. Two single quotes within a string tell Oracle
to use it a a single qoute, not as the string terminator. Like 'ab''cd'
gets you ab'cd and '''' gets you '.



Arjan.



Received on Fri Mar 12 1999 - 11:44:12 CST












Original text of this message













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