View with a parameter

From: Wim de Lange <w.delange_at_alcontrol.nl_nospam>
Date: Tue, 11 Mar 2003 10:29:01 +0100
Message-ID: <MPG.18d7c393260f37379896f8@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 - 03:29:01 CST