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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] SQL statement need help !!

RE: [Q] SQL statement need help !!

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Fri, 23 Feb 2001 11:29:12 -0800
Message-ID: <F001.002BC382.20010223111610@fatcity.com>

SET PAGESIZE 0 suppresses the headings

Rick

> -----Original Message-----
> From: L [SMTP:leed_at_chele.cais.net]
> Sent: Friday, February 23, 2001 2:08 PM
> To: oracle-l_at_fatcity.com; oracledba_at_quickdoc.co.uk
> Subject: [Q] SQL statement need help !!
>
> I have following sql statemen when runninf does NOT show heading. Can
> anyone tell me why?
>
>
> set pagesize 0
> set linesize 132
> set heading on
>
> column SPID heading 'SPID' format 99999 justify LEFT
> column O_USER heading 'USER NAME' format A12
> column TERMINAL heading 'Terminal' format A10
> column PROGRAM format A60
>
> select
> to_number(p.SPID) SPID,
> 'O:' || lower(s.USERNAME) o_user,
> s.sid, s.serial#,
> s.TERMINAL,
> to_char(logon_time, 'HH24:MI:SS') logon_time
> from v$process p,
> v$session s
> where p.addr=s.paddr (+)
> and p.spid is not null
> and s.username != 'UNKNOWN'
> order by s.logon_time,s.username,spid;
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Feb 23 2001 - 13:29:12 CST

Original text of this message

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