Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Unanswered: what does this exactly mean?

    COLUMN sid format 9999 heading "SID"
    COLUMN spid format 9999 heading "PID"
    COLUMN username format a30 heading "User Name"
    COLUMN osuser format a30 heading "OS User"
    SET FEEDBACK OFF VERIFY OFF
    SET lines 132 pages 59

    <<< procedure>>>

    Spool off
    Cheers
    Etravels

  2. #2
    Join Date
    Oct 2004
    Posts
    145
    It is simply output formatting commands from sqlplus.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by etravels
    COLUMN sid format 9999 heading "SID"
    COLUMN spid format 9999 heading "PID"
    COLUMN username format a30 heading "User Name"
    COLUMN osuser format a30 heading "OS User"
    SET FEEDBACK OFF VERIFY OFF
    SET lines 132 pages 59

    <<< procedure>>>

    Spool off
    If you have a column called SID in your select, format it as a 4 digit number with no leading zeros and use "SID" as the column header.

    If you have a column called SPID in your select, format it as a 4 digit number with no leading zeros and use "PID" as the column header.

    If you have a column called USERNAME in your select, format it as a 30 character character string and use "User Name" as the column header.

    If you have a column called OSUSER in your select, format it as a 30 character character string and use "OS User" as the column header.

    SET FEEDBACK OFF - Do not show the "xxx rows returned" after the select
    SET VERIFY OFF - Do not print out lines from the select that have a variable substatution.
    SET lines 132 pages 59 Set the max width of an output line to 132 characters and the max length of a page to 59 lines.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •