Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Output in SQL Worksheet or SQLPlus
Thanks! With your help and the other kind people who responded, I was able
to solve my problem. :)
Tom
Jonathan Gennick wrote in message
<37c204b2.43424951_at_netnews.worldnet.att.net>...
>If you are just executing a SQL query, then don't use PL/SQL
>at all. Execute the SELECT by itself, and SQL*Plus (or
>worksheet) will display the results.
>
>From PL/SQL, there are a couple methods you could use. One
>is to use the DBMS_OUTPUT package. For example:
>
<snip> Received on Sat Aug 21 1999 - 15:59:08 CDT