HP3000-L Archives

November 2003, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: OT: PL/SQL suppress default headings
From:
Evan Vaala <[log in to unmask]>
Reply To:
Evan Vaala <[log in to unmask]>
Date:
Wed, 26 Nov 2003 12:29:01 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (143 lines) 
Also,

You may have to start sqlplus with the "-s" command line option.

I know that in 8.1.7, if you do not specify -s, the "SQL>" prompt will be
displayed in your spool file.

Might be different in 9i.

Evan



On Wed, 26 Nov 2003 12:09:24 -0500, Tim Cummings
<[log in to unmask]> wrote:

>John,
>
>It's SET HEADING OFF
>
>Tim
>
>-----Original Message-----
>From: John Penney [mailto:[log in to unmask]]
>Sent: Wednesday, November 26, 2003 12:05 PM
>To: [log in to unmask]
>Subject: [HP3000-L] OT: PL/SQL suppress default headings
>
>
>HP Users:
>
>Happy Thanksgiving to all of our friends in the US. The rest, well, Happy
>Wednesday!
>
>Now for my question: and I know that this is trivial to anyone who writes
>this stuff on a semi-regular basis....I want to suppress the default
>headings that print in my sqlplus report.
>
>Environment:
>
>Oracle 9.2.0.1.0
>
>Windows 2000
>
>PL/SQL (sqlplus)
>
>code snippett:
>
>-- * PROGRAMMER   : acks to Krishna Kakatur (by JMP0)      *
>-- *                                                       *
>-- *********************************************************
>
>
>col object_type heading " "
>col owner       heading " "
>col object_name heading " "
>
>set pagesize 60;
>set feedback off;
>set echo off;
>set termout off;
>spool report_invalid.txt;
>
>
>break on object_type skip 2
>ttitle center 'Objects that have an "Invalid" Status in dba_objects' skip 2
>
>SELECT distinct decode(object_type, 'PACKAGE BODY','PACKAGE', object_type)
||
>' '||owner||'.'||object_name
>FROM  dba_objects  WHERE status='INVALID'
>AND   object_type
>IN ('PACKAGE','PACKAGE BODY','VIEW',
> 'FUNCTION','PROCEDURE','TRIGGER')
>group by object_type, owner, object_name;
>
>/
>
>spool off
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Output
>
>              Objects that have an "Invalid" Status in dba_objects
>
>DECODE(OBJECT_TYPE,'PACKAGEBODY','PACKAGE',OBJECT_TYPE)
||''||OWNER||'.'||OBJ
>ECT_
>---------------------------------------------------------------------------
-
>----
>TRIGGER ASR.BIU_TBLACCTADJUSTMENTS
>TRIGGER ASR.BIU_TBLACCTADJUSTMENTSABST
>TRIGGER ASR.BIU_TBLACCTCONTACTS
>TRIGGER ASR.BIU_TBLACCTOG
>TRIGGER ASR.BIU_TBLACCTOGEQUIP
>TRIGGER ASR.BIU_TBLACCTOGPROD
>TRIGGER ASR.BIU_TBLACCTOGWELLS
>TRIGGER ASR.BIU_TBLACCTPP
>TRIGGER ASR.BIU_TBLACCTPPCONTACTS
>TRIGGER ASR.BIU_TBLACCTPPDETAIL
>TRIGGER ASR.BIU_TBLACCTPPFARM
>TRIGGER ASR.BIU_TBLACCTPPFREEPORT
>
>I don't want to see the
>
>"DECODE(OBJECT_TYPE,'PACKAGEBODY','PACKAGE',OBJECT_TYPE)
||''||OWNER||'.'||OB
>JECT_"
>
>as it is irrelevant.
>
>Best
>
>
>
>
>
>John M Penney
>Systems Programmer
>Production Services
>Information Services Department
>Pierce County
>Tacoma, WA
>253-798-6215
>253-798-6680 Fax
>[log in to unmask]
>www.co.pierce.wa.us
>
>The opinions expressed herein reflect those of the sender.
>They do not necessarily reflect the opinions of  Pierce County
>unless specifically stated otherwise.
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2