Passing parameters to View
728140Apr 21 2010 — edited Apr 21 2010Hi ,
create or replace view test(fromdate varchar,todate varchar)
as
select * from tbl_purchase
where pur_date between fromdate and todate
when i execute this view , i get an error saying that missing right parentheses....
is it the correct way of passing paramters...