Skip to Main Content

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!

Problem creating View with Parameters

782649Jul 1 2010 — edited Jul 2 2010
Hello,

i'm new working with PL/SQL and i'm trying to create a view that accepts parameters. I have two tables that i merge with UNION first, I would like to query a view that do that with parameters. It looks like that:

TABLE 1
col1,
col2,
col3

TABLE2
col1,
col2,
col3,
col4,
col5

View:
CREATE VIEW ALL_ADM_VIEW AS SELECT COL1, COL2, COL3 FROM
(SELECT COL1, COL2, COL3 FROM TABLE1
UNION COL1, COL2, COL3 FROM TABLE2
WHERE CURRENT_DATE BETWEEN TABLE2.COL4 AND TABLE2.COL5) U
WHERE U.COL3='PARAMETER';

I need to put the parameter value 'PARAMETER' for the View. Any Help?

Thanx in advance
This post has been answered by SomeoneElse on Jul 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2010
Added on Jul 1 2010
9 comments
1,299 views