Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    6

    Red face Unanswered: Need help in Setting the Linesize

    Hi,
    I am running a SQL Query from SQL Plus. The output has 3 columns out of which the first column is varchar, the second is Number and the third column is Date type.
    I am using the following environment before running the SQL

    SET LINES 10000
    SET LINESIZE 60
    SET PAGESIZE 20000
    SET SPACE 0
    SET FEEDBACK OFF
    COLUMN 'ABCDE' FORMAT A15
    COLUMN 'ABCDE ATTEMPTS' FORMAT 999999
    COLUMN 'ABCDE TIME' FORMAT A9

    The script when executed wraps the data of column 2 and column 3
    like this
    ABCDE NO OF ATTEMPTSATTEMPT T
    ------------------------------------------------------------------------
    ANONYMOUS 13710-DEC-06

    Can u pls help in ensuring that the data of column 2 and 3 are shown seperately. I tried changing the line size to 80 but it did not worked

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Basically, you don't have to do absolutely nothing to separate column data. It is separated by default.

    Now, how come you thought that LINESIZE has something to do about it? Do you, actually, know what the other SET commands do? For example, FEEDBACK? or PAGESIZE? or SPACE? Or did you simply pick those from some sample script and copy-pasted them to your script?

    I *know* what is wrong, but I also believe you'll learn something if you find out by yourself what all those SET commands do. Because, the answer is out there.

  3. #3
    Join Date
    Dec 2006
    Posts
    6
    Hi,
    I am new to SQL and just started learning it.....I thought that since the columns were getting truncated, it would be problem with Linesize.
    But then I also tried to increase the space from 0 to 2 and it worked !!!!
    Was a good learning

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I'm glad you found the solution!

Posting Permissions

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