Re: PL/SQL

Select ... From CAN be used in PL/SQL without an i"into" clause in the syntax. To avoid INTO, Use a Cursor.

Cursor c1 is Select Empno From Emp;

or

FOR I in (Select Empno from Emp) Loop

• Processing. ... End Loop;

Sunder.

Mike heydon wrote:

> > Can someone explain Why "Select ... From.." without into can't be
> used
> in
> > PL\SQL ?
>
> Select ... from ... is part of SQL not PL/SQL.
>
> There are 3 distinct sets of commands ...
>
> SQL
> SQL PLUS
> PL/SQL
>
> Whilst all 3 may be included in a script, you cannot mix them together
> in
> the same block or statements.
>
> Regards
> Mike Heydon
Received on Mon Oct 27 1997 - 00:00:00 CST