Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    38

    Unanswered: Spooling Output in Oracle

    I have figured how to spool my output to a list file.
    The question I have is on how my output looks.

    It looks something like the following.

    Var1Data Var2Data
    Var3Date Var4Data
    Var5Data Var6Data

    I want my data to print out on one line so that it could like something like the following:
    Var1Data Var2Data .... Var20Data <-- Observation 1
    Var1Data Var2Data .... Var20Data <---Observation 2
    ....................................
    Var1Data Var2Data ..... Var20Data <---Observation 100

    What is the Oracle setting to make sure my linesize is quite large so that I can open and view my output in notepad.

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Try something like:SET LIN 512 TRIMS ON
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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