Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    40

    Question Unanswered: turn off padding?

    i'm trying to run sqlplus with file like sqlplus name/pw @file.
    The file contains this.


    set heading off
    set termout off
    spool RealName.bat
    select '@SET realName=' || username || '*' from user_users;
    spool off


    as a result of the spool, RealName.bat has the correct output, but it is padded to 81 characters long. Does anyone know how i can make the spool return '@SET realName=BLAH' with no blank spaces at the end?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SET TRIMSPOOL ON

Posting Permissions

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