Insert into Table

From: lve <lve3162_at_yahoo.com>
Date: 25 May 2002 18:38:07 -0700
Message-ID: <93096888.0205251738.21734e31@posting.google.com>

I want to create a view like this:

Create or replace view MyView
(StartDateVARIABLE VARCHAR2,EndDateVARIABLE VARCHAR2) as
select a.col1,sum(b.col2)
from table1 a,table2 b
where a.col1=b.col1 and
a.hiredate between
StartDateVARIABLE AND EndDateVARIABLE
group by a.col1

---

AND THEN I WANT TO DO SOMETHING LIKE THIS: insert into Table3
Select * from MyView('01-jan-2002','31-mar-2002')

how can I accomplish this

Thanks in advance Received on Sat May 25 2002 - 20:38:07 CDT