Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Is alternative quoting supported in 9i?

Is alternative quoting supported in 9i?

From: <csimam_at_gmail.com>
Date: Sat, 22 Dec 2007 19:12:21 -0800 (PST)
Message-ID: <cbbef377-fc37-427a-8f2c-55ef06072da9@21g2000hsj.googlegroups.com>


Hello,

Is the alternative quoting mechanism in 10g supported in 9i? In other words, the following query is understood in 10g:

select * from companies where name= Q'[Bob's Hotdogs]'

but will it be understood in 9i? or do I need to go back to:

select * from companies where name='Bob''s Hotdogs'

thanks in advance. Received on Sat Dec 22 2007 - 21:12:21 CST

Original text of this message

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