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: Setting up Oracle for NT - 8.0.4

Re: Setting up Oracle for NT - 8.0.4

From: Robert Ottohall <rob_at_ohall.com>
Date: Tue, 10 Nov 1998 08:35:46 +0100
Message-ID: <728qd6$ck9$1@goof.de.uu.net>


use signle quotes to enclose the desired string

Select * from swpipes where pipeno = '"A1234"'

oldgent_at_hotmail.com wrote in message <727pcd$8f$1_at_nnrp1.dejanews.com>...
>We recently purchased Oracle 8 for NT. We have an application which runs
in
>SQL Server, but does not run in Oracle. It appears the main problem is
that
>double quotations were used within the SQL statements generated by the
>application program.
>
>Ex. Select * from swpipes where pipeno = "A1234"
Received on Tue Nov 10 1998 - 01:35:46 CST

Original text of this message

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