Xref: alice comp.databases.oracle.misc:50120 comp.databases.oracle.server:79201 comp.databases.oracle.tools:37821
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed2.news.nl.uu.net!sun4nl!EU.net!news0.Belgium.EU.net!newsr.Belgium.EU.net!not-for-mail
From: =?iso-8859-1?Q?Jo=EBl?= Dessart <jocky@bigfoot.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools,comp.databases.oracle.server
Subject: ENCLOSE QUOTE CHAR. IN SQL ?
Date: Wed, 29 Dec 1999 09:39:51 +0100
Organization: Paris - Nordkapp
Lines: 22
Message-ID: <3869C8D6.27ABBD6E@bigfoot.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.7 [en] (Win95; I)
X-Accept-Language: en

Hi !

I want to enclose the quote char before and
after a reference number in a SQL statement.

E.g. : ref. nbr=  0026121.07
After SQL:   '0026121.07'

How could I do this in script since something
like: select ''' || table.refnbr || ''' from table;
does not work ?

Is there a mean to say that the quote must be
kept as character and not as limit of an
explicit string in this query (kind of ESCAPE char
for LIKE operator...) ?

                        Thanks a lot !

                                    Joel
                                    mailto:jocky@bigfoot.com