Re: SEARCHING FOR TEXT PATTERN IN "LONG" COLUMN

SAL wrote:

>All,
>I would like to do something like:
>select view_name from user_views where text like 'CURRENT%';
>Obviously I can not do it because TEXT column in user_views is LONG. Is
>there any way around it? I have looked at many dbms stored procedures, but
>can not find one that will do this.
>Any help will be appreciated.
>
>Sal
>
>
>
>

Use an in-line view.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)