Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i store and retrieve strings with ' (Single quote) ??

Re: How can i store and retrieve strings with ' (Single quote) ??

From: David Russell <user_at_msn.com>
Date: 1997/12/02
Message-ID: <01bcff65$03f503e0$f15395c1@thor>#1/1

From SQLPLUS you can use SET ESCAPE ... or if you are using a LIKE operator then use the escape clause (e.g select * from tab1 where col1 like 'ABC%' escape '\';)

Regards
David Russell Received on Tue Dec 02 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: Phil Herring: "Re: How can i store and retrieve strings with ' (Single quote) ??"
Previous message: Bharat Yarlagadda: "How can i store and retrieve strings with ' (Single quote) ??"
In reply to: Bharat Yarlagadda: "How can i store and retrieve strings with ' (Single quote) ??"
Next in thread: Phil Herring: "Re: How can i store and retrieve strings with ' (Single quote) ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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