Re: Pass variable into View?

Hello, Mark,

near 09:11 19-Jul from zzzzzz45_at_hotmail.com:

> Hi,
>
> I'm trying to write a view that returns a historical view of records
> as of a certain date. The records come from a live and historical
> table and I need to return the records as they were in the live table
> on various dates. The SQL to do this is no problem but it requires a
> date value in a where clause in an inner select (the sql is below for
> reference - the date value that needs to be variable is hardcoded as
> '01/01/2001'). Can I somehow pass this into a view or is a view the
> correct approach?

Try to use package variable (or user-defined function) in view. Set the value before using view.

> Thanks,
> Mark

[...]

-- 
wbr,
Wit.