Re: Print in PL/SQL
From: Álvaro Palma Aste <queria_direccion_at_el.perla?>
Date: 18 Jan 2002 21:50:57 GMT
Message-ID: <a2a5c1$l3q$2_at_news.cec.uchile.cl>
Date: 18 Jan 2002 21:50:57 GMT
Message-ID: <a2a5c1$l3q$2_at_news.cec.uchile.cl>
Stjepan Brbot escribió:
>How to print the simplest message in PL/SQL? I.e. how to print on screen
>all rows of cursor when you execute this procedure?
>PROCEDURE ABC IS
> CURSOR curABC IS SELECT * FROM tableA;
>BEGIN
> FOR row IN curABC LOOP
>??? print row ???
> END LOOP;
>END;
>--
>Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
set serveroutput on size 1000000
In the line you want to print
dbms_output.put_line('string');
-- Atte. Álvaro Palma Aste Grupo de Ing. Biomédica Depto. de Ing. Eléctrica - U. de Chile apalma_at_cec.uchile.adivinaReceived on Fri Jan 18 2002 - 22:50:57 CET