Re: CHALLENGING:: Dynamic OR Session specific Views. Possible?

vistav20_at_yahoo.com wrote:
> Hi,
>
> Is it possible to create a view or a version of data accessible through
> same object name (table or view), which returns different values for
> different sessions?
>
> Here is what I am trying to do:
>
> I need to create a view with a different underlying query each time it
> is accessed. But I still need it to behave like a static object so I
> could use it to link with an external tool (so, it's name and structure
> etc will not change, just the underlying query and it's where clause
> willl change). To make matters more complex, the query would be
> different for different people logged in, hence the SESSION SPECIFIC
> contstraint.
>
> Any ideas?
>
> thanks much,
> Mark

No version number ... do you think the solution is generic going back to version 4?

If 9i or above use a pipelined table funtion.

http://www.psoug.org
click on Morgan's Library
click on Pipelined Table Functions

But I am agreement with Jim and Sybrand ... what you are asking has most of the hallmarks of the wrong solution to an unstated problem.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)