i'm trying to run sqlplus with file like sqlplus name/pw @file.
The file contains this.
set heading off
set termout off
select '@SET realName=' || username || '*' from user_users;
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?