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: How to have single quotes in an update/insert statement? (Simple newbie question)

Re: How to have single quotes in an update/insert statement? (Simple newbie question)

From: rob <rob_at_dsdelft.nl>
Date: Thu, 11 Oct 2001 09:43:35 +0200
Message-ID: <9q3iip$ptf$1@news.tudelft.nl> 





>




> Update collection3

> Set item='Rah's Book'

> Where worth=222;



Set item='Rah''s Book' (two qoutes)


or


Set item='Rah'||chr(39)||'s Book'



Rob
Received on Thu Oct 11 2001 - 02:43:35 CDT












Original text of this message













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