Re: basic pl/sql question

Hi Dennis

> I created a script containing a cursor. In the begin section, I am
> looping through each of the records in this cursor. What I want to
> do (for starters) is to print out each record that it finds. What
> command can I use to print out a single line of output? Am I limited
> to the "select" statement to producer output to the screen? There
> must be something else, right?
>

Where do you produce output ?

If in SQLPLUS you can :

set output on

• an then declare cursor c is select ...... from table... ; x c%ROWTYPE; begin

   open c;
   loop
    fetch c into x ;
    exit when c%NOTFOUND;
    dbms_output.put_line( x.col1 || x.col2 .... ) ;   end loop;
end ; Received on Tue Jun 30 1998 - 23:03:17 CEST