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?
Not really. But there is a workaround I am aware of:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=130ba93a.0211121307.2ae47856%40posting.google.com
Received on Tue Mar 11 2003 - 11:46:30 CST
