Problem creating View with Parameters
782649Jul 1 2010 — edited Jul 2 2010Hello,
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