Re: PL/SQL -- huh?

Chetan Jujuneja (FVZW96A_at_prodigy.com) wrote:
: You bcan use DBMS_OUTPUT.PUT_LINE(text) instead of message. Note however
: you need to set SERVEROUTPUT ON before executing this statment.
:
: As regards using multiple table you can use any DML statement involving
: multiple tables in a single block of PL/SQL code.
:
: Chetan Juneja
: Quientesence Systems
: E Mail FVZW96A_at_prodigy.com
:

Another - slightly older trick - is to

SELECT "Output String" FROM DUAL;

to get something to the screen...

-- 
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I