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

[541 byte] By [Suraweeraa] at [2007-11-26 19:24:11]
# 1
Try using a PreparedStatement and insert a parameter placeholder ("?") instead of "TO_DATE('2007/2/23', 'YYYY/MM/DD')".> Pls Help as soon as possibleUsually I don't, good you told me ...
quittea at 2007-7-9 21:46:37 > top of Java-index,Java Essentials,Java Programming...