Re: Is alternative quoting supported in 9i?

Comments embedded.
On Dec 22, 9:12 pm, csi..._at_gmail.com wrote:
> Hello,
>
> Is the alternative quoting mechanism in 10g supported in 9i?

No.

> 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