Insert into Tabl

From: lve <lve3162_at_yahoo.com>
Date: 25 May 2002 18:36:34 -0700
Message-ID: <93096888.0205251736.5ff8126e_at_posting.google.com>

[Quoted] 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 Sun May 26 2002 - 03:36:34 CEST