Re: help with a SQL/view problem

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 16 Feb 2010 11:09:19 -0800
Message-ID: <bf46381002161109x652ce7e8u787a5af2a2206574_at_mail.gmail.com>

On Tue, Feb 16, 2010 at 5:30 AM, Bill Ferguson <wbfergus_at_gmail.com> wrote:

> Hi Norman,
>
> Thanks for the reply. On my system, for whatever reason, I don't have
> to escape the underscore. The table names retrieved are the ones I
> want, not the superflous lookup tables or other system generated
> tables. I tried escaping the underscore per your suggestion, and I got
> "no rows returned", so maybe it's a Windows thing?
>
>

No, it's a SQL thing:

http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_escape_special_characters_when_writing_SQL_queries.3F

http://download-west.oracle.com/docs/cd/B12037_01/java.101/b10979/ref.htm#i1005208 <http://download-west.oracle.com/docs/cd/B12037_01/java.101/b10979/ref.htm#i1005208>

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 16 2010 - 13:09:19 CST