Re: can I join 2 tables in PL/SQL??

From: A. Bogomol <bogomol_at_investbank.ru>
Date: Thu, 29 Mar 2001 08:46:36 +0300
Message-ID: <9455EAF0C99FD111B85B0060B067688A04DFDB02@E40>

" srcnckpc"@hotmail.com <" srcnckpc"@hotmail.com> ïèøåò â ñîîáùåíèè <3AC2730E.4E3AD5AC_at_hotmail.com> ...
>I have the Oracle8 PL/SQL Programming (S.URman) book but I did not find any
>examples of 2 tables being joined inside a PL/SQL block.
>

Look through cursors ,
for example:

Declare
cursor pjoin is select SELECT e.field, d.field FROM emp e, dept d WHERE e.deptno = d.deptno;
rjoin pjoin%rowtype;
begin
Open pjoin;
Fetch pjoin into rjoin;
... Received on Wed Mar 28 2001 - 23:46:36 CST