Sending a parameter to a Oracle view
I want to create a oracle view with a variable and i want to change the value of variable according to my needs.
Can i Do This.
Query of view is a complex one assume as like this
SELECT ........ FROM
( SELECT ........ FROM .............
WHERE tempDate=TO_DATE('2007/2/23','YYYY/MM/DD')
)
WHERE ...............................
Date should be a variable.
Variable should in a sub query.
Pls Help as soon as possible

