Re: VIEWS - Need Help

[Quoted] I guess I wasn't to clear. Because I need to pass parms into the view, i.e. billing period, client etc, I was trying to find out if it was possible. The system is billing period sensitive. If the current month is selected, many tables are joined to extract the data. If historical data is requested, a different table is selected that contains all data. To avoid many joins, we created a denormalized table containing all data. Once the billing period is closed, the data becomes reference historical information. Quicker response time.

Can I create a procedure that call the view?

On Thu, 23 Jul 1998 15:41:24 GMT, NeedaHoliday wrote:

>Requirement:
>
> 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 Fri Jul 24 1998 - 14:28:07 CEST