Create a pipeline table function

a as (select rownum line#, x.line1 from EXT_SPECIAL_1 x ),
s as (select * from a where a.line1 like ‘*** MESSAGE%’)
select a.*
  from a, s
¬†where a.line# (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me  
New User Registration
*Required field