SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing parameters into a view

632290Apr 4 2008 — edited Apr 4 2008

Hi I am new to this so could someone please help me. I have created a view

CREATE VIEW tutorial AS
SELECT ot.ordno, ot.orddate, ol.prodno, p.prodprice, ol.qty
FROM ordertbl ot, ordline ol, product p
WHERE ot.ordno = ol.ordno AND
ol.prodno = p.prodno AND
TO_CHAR(orddate,'Day') LIKE 'Sunday%'

is it possible for me to create this view to accept a parameter so that i cood run the same view to return results for different days i.e. saturday, monday etc

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2008

Added on Apr 4 2008

3 comments

8,653 views