Re: Print screen without dbms_output

Article View: comp.databases.oracle.misc

Article #115

Back to comp.databases.oracle.misc Previous Next

#115

From: gmei
Date: Wed, 06 Sep 2000 19:55

32 lines
1836 bytes

If you use sqlplus or sql worksheet, the result will be on screen
automatically after you issue the query.

Or you can use UTL package and write stuff to a file.

Guang

In article <JGst5.456$zx3.9170@iad-read.news.verio.net>,
  "Emre Akbag" <akbag@scr.siemens.com> wrote:
> Is there any way of printing a result data set of a select query on
screen
> without using dbms_output?
>
> --
> Emre AKBAG
>
> Data Mining, Imaging & Visualization Dept.
> Siemens Corporate Research
>
> Ph:   (609) 734.6500 ext. 2260     Fax: (609) 734.6565
> E-mail:   akbag@scr.siemens.com
>
> Siemens Corporate Research,
> 755 College Rd East,
> Princeton, NJ 08540
>
>

Sent via Deja.com http://www.deja.com/
Before you buy.

Technical Details

Message-ID: <8p67ek$ao6$1@nnrp1.deja.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-east!supernews.com!news-feed.riddles.org.uk!newsfeed.direct.ca!look.ca!howland.erols.net!netnews.com!newspeer1.nac.net!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail

References: <JGst5.456$zx3.9170@iad-read.news.verio.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,17237e1dde3b8d83
X-Google-Attributes: gidfb53f,public
X-Google-Thread: f99a8,17237e1dde3b8d83
X-Google-Attributes: gidf99a8,public
X-Google-ArrivalTime: 2000-09-06 13:00:30 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-east!supernews.com!news-feed.riddles.org.uk!newsfeed.direct.ca!look.ca!howland.erols.net!netnews.com!newspeer1.nac.net!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: gmei@my-deja.com
Newsgroups: comp.databases.oracle.misc,hannover.uni.comp.oracle
Subject: Re: Print screen without dbms_output
Date: Wed, 06 Sep 2000 19:55:10 GMT
Organization: Deja.com - Before you buy.
Lines: 32
Message-ID: <8p67ek$ao6$1@nnrp1.deja.com>
References: <JGst5.456$zx3.9170@iad-read.news.verio.net>
NNTP-Posting-Host: 216.126.162.253
To: akbag@scr.siemens.com
X-Article-Creation-Date: Wed Sep 06 19:55:10 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x62.deja.com:80 (Squid/1.1.22) for client 216.126.162.253
X-MyDeja-Info: XMYDJUIDgmei

Reply to Parent Message