SET PAGESIZE 0 suppresses the headings Rick > -----Original Message----- > From: L [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 23, 2001 2:08 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] > to subscribe send a blank email to [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
