Re: PL/SQL how-to procedure

CG wrote:
>
> ...Can anyone tell me if it is possible to create a procedure
> with a simple 'select' statement ?... ie. select * from table_a;

  You must use INTO clause if this statement is in the procedure body. On the other hand, if you use this statement in the declaration of a cursor, no INTO clause is required.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.