Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do i print to the screen in SQL plus

Re: How do i print to the screen in SQL plus

From: Fenella Tan <fenella_at_voicenet.com>
Date: 1997/10/14
Message-ID: <61ufvl$kfp$1@news3.voicenet.com>#1/1

Don't forget to set in your SQLPLUS option: set serveroutput on [size 1000000]
[optional]

Tina Tran wrote in message <01bcd693$d45f8e60$2aaeb6cc_at_dino>...
>Use dbms_output package which is located in
>$ORACLE_HOME/rdbms/admin/dbmsotpt.sql
>
>Casper Thrane <ct_at_benau.dk> wrote in article
><343EB4F6.5A51A79F_at_benau.dk>...
>> How do I print to the screen in SQL Plus from a procedure.
>> I can't use "prompt" so what can I do?
>> --
>> Casper Thrane
>> Systemdeveloper
>> Benau A/S
>>
Received on Tue Oct 14 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US