Toad World® Forums

Output from sqlplus

2 different databases. Same server. Linesize is set to 32000 characters. What parameter am I missing that is causing the difference in output. I’ve checked NLS parameters and initialization parameters. Can’t see what I’m missing. Any ideas?

SQL> select to_char(5, ‘S0999999.90’), 1 from dual;

TO_CHAR(5,’ 1


+0000005.00 1

SQL> select to_char(5, ‘S0999999.90’), 1 from dual;

TO_CHAR(5,‘S0999999.90’) 1


+0000005.00 1

Thanks for any help you can give.