Re: Insert into Tabl

What about:
Create or replace view MyView as
select * from table1 a, table2 b
[Quoted] where a.col1 = a.col2

and then you can query this with a statemant like this:

select * from MyView where hiredate between '01-jan-2002' and '31-mar-2002';

Regards Veit

CAFM Developer

--
http://www.kloburgvibes.at
"lve" <lve3162_at_yahoo.com> schrieb im Newsbeitrag
news:93096888.0205251736.5ff8126e_at_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