Can Oracle Support Double Quotes?

From: Rob Kraft <robkraft_at_email.msn.com>
Date: Mon, 23 Nov 1998 21:56:54 -0600
Message-ID: <ekBWw41F#GA.50@upnetnews05>

I have an application written using double-quotes to deliminate strings. It works on SQL Server, Sybase, and Access. We want to port it to Oracle but can't figure out how to get Oracle to accept double quotes as the string delimiter. Is there an environmental parameter we can change?

An example of a query we are trying to run is Select * from customers where Lastname = "Ellison"

I know that we can make it work by replacing the double-quotes with single quotes, but that requires analyzing thousands of lines of code to make the changes. I'm looking for an easier way. Can Oracle do this?

Rob Kraft
robkraft_at_msn.com Received on Mon Nov 23 1998 - 21:56:54 CST