VIEWS - Need Help

[Quoted]         Enter logic in the view to determine which part of the view is created.

i.e
Create or replace VIEW name AS

        if IN_stat_cd = 'COM'

            Select .........

        else

            Select ........

              end if

Is this possible and how.

I can't find an example.

Jim Received on Thu Jul 23 1998 - 17:41:24 CEST