Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting up Oracle for NT - 8.0.4
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