Re: Is alternative quoting supported in 9i?
Date: Wed, 26 Dec 2007 07:36:36 -0800 (PST)
On Dec 22, 9:12 pm, csi..._at_gmail.com wrote:
> 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?
No, it won't be understood in any release of 9i:
SQL> select q'[Bob's Hotdogs]' from dual; select q'[Bob's Hotdogs]' from dual
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
> or do I need to go back to:
> select * from companies where name='Bob''s Hotdogs'
> thanks in advance.
David Fitzjarrell Received on Wed Dec 26 2007 - 09:36:36 CST