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.