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.

Comments embedded.
On Dec 22, 9:12*pm, csi... (AT) gmail (DOT) com wrote:
No.

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


David Fitzjarrell