can we select two tables data into one variable

 Hi,

i am trying to fetch the whole emp,dept data into one record variable

declare

type rec is record(v_rec emp%rowtype,v_dec dept%rowtype);

type d is record ( v rec);

f d;

--r rec;

begin

select e.* into f.v.v_rec from emp e,dept d where e.deptno=d.deptno and e.empno=7788;

select d.* into f.v.v_dec from emp e,dept d where e.deptno=d.deptno and e.empno=7788;

dbms_output.put_line(f.v.v_dec.dname||'   '||f.v.v_dec.loc||'  '||f.v.v_dec.deptno);