SQL & PL/SQL

Hi,

I have a requirement like this.

cursor c1 is

select a,b,c,d from abc

UNION

select e,f,g,h from def;


I am replacing cursor with collection variables.

Created collection variables for both the select statements as

select a,b,c,d BULK COLLECT INTO coll_abc from abc;

select e,f,g,h BULK COLLECT INTO coll_def from def;

Now, I want to get the UNION of both these collections into another collection variable.

Can I write

select * BULK COLLECT INTO coll_abc_def from coll_abc,coll_def;

Thanks

Rajiv