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
In oracle you use double quotes for aliases of columns
strings must be enclosed in single quotes.
if your table contains double quotes in columns
try this ( oracle only):
Select * from swpipes where pipeno = chr(34) || 'A1234' || chr(34)
34 is the ascii value for double quote
and the || is the concat operator for Strings
Regards
Rob
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"
>
>Is there a setting with Oracle which will allow it to accept such a SQL
>statement without giving an error?
>
>Thanks in advance for your help.
>
>oldgent_at_hotmail.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 10 1998 - 01:29:06 CST