Re: SQL Quest...

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 10 Feb 2004 11:16:31 GMT
Message-ID: <j43Wb.50461$Wa.32288@news-server.bigpond.net.au>

"Noel" <tbal_at_go2.pl> wrote in message news:c0aclh$c6f$1_at_inews.gazeta.pl...
> I'm now working on moving one Oracle Application to another
> and faced one problem.
> In the name of data objects i'm using '_' char.
> Now i would like to find all objects which name constains '_'.
> First obvious solution didn't succes,
> SELECT *
> FROM ALL_OBJECTS
> WHERE OBJECT_NAME LIKE 'TAB_%';
> since '_' means 'any char'.
>
> What i better and correct solution? (My answer is on next page of post).
> --

Hi Noel

SELECT *
FROM ALL_OBJECTS
WHERE OBJECT_NAME LIKE 'TAB/_%' ESCAPE '/'; should do the trick (the escape clause defines a special char which when place in front of the "_" disables it's wildcard behaviour).

Good Luck

Richard Received on Tue Feb 10 2004 - 05:16:31 CST