Re: View with a parameter

A view is like a table, so make your view without the where/order by and when you want to view the
data you do

select *
from my_view
where <whatever>
order by <whatever else>

"Wim de Lange" <w.delange_at_alcontrol.nl_nospam> wrote in message news:MPG.18d7c393260f37379896f8_at_news.euronet.nl...
>
> For reporting purposes I want to define a crosstab view as follows:
>
> select 1+floor((rownum-1)/3) as rownumber,
> max(decode( mod(rownum,3), 1, article_id, null)) as col1,
> max(decode( mod(rownum,3), 2, article_id, null)) as col2,
> max(decode( mod(rownum,3), 0, article_id, null)) as col3
> from (select article_id from article where order_id=6 order by name)
> group by floor((rownum-1)/3)
>
> In this view the part "order_id = 6" is the "parameter" of this view. Is
> it possible to define a parameter in a view? So that I can pass the
> information about the order I want to this view?
>
> --
>
> Groetjes,
> Wim de Lange
Received on Tue Mar 11 2003 - 07:10:24 CST