Re: Funny result set in SQL query

From: Hilary Shreter <shreterh_at_sprynet.com>
Date: 1998/01/14
Message-ID: <01bd209a$689fd6c0$8289aec7@vogmudet>#1/1

For sqlplus there's a workaround [not exact quote - I'm at home] select table_name from dba_tables where table_name like 'PRO/_%' escape '/'

I found this when I was having trouble distinguishing PA_ from PAY_ !.

There's a SET ESCAPE also -- I never tried it.

Karl E. Jørgensen <kjorg_at_email.msn.com> wrote in article <eRCUQtBI9GA.225_at_upnetnews03>...
> That's correct. The underscore is a matches ANY character:
>
> Select table_name from dba_tables where table_name like 'PRO_';
>
> could return stuff like
>
> 'PROA'
> 'PROB',
> 'PROX'
>
> etc.
>
> --
> Karl
> Oracle Certified DBA
> Christopher Jusitce wrote in message <34bad3cb.806387_at_news.erols.com>...
Received on Wed Jan 14 1998 - 00:00:00 CST