Re: help with a SQL/view problem
- From: Jared Still <jkstill@xxxxxxxxx>
- To: wbfergus@xxxxxxxxx
- Date: Tue, 16 Feb 2010 11:09:19 -0800
On Tue, Feb 16, 2010 at 5:30 AM, Bill Ferguson <wbfergus@xxxxxxxxx> 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
Other related posts:
