SQL result formatting on TO_CHAR different in 12c
Date: Thu, 13 Apr 2017 14:13:00 -0600
Message-ID: <CAJzM94BvoLLAvcdD-b1rbyGJHBpebHikgmGj6Y4sycVf4FQXMA_at_mail.gmail.com>
Oracle EE 12.1.0.2, 2-node RAC
RHEL 5 We recently upgraded from 11.2.0.4 to 12.1.0.2. We have several scripts running out of crontab to monitor various aspects of our applications. The analysts are seeing different formatting of the results of these scripts in 12c than they did in 11g.
11g - all output was on one line - linesize set to 1000, only 10 columns, date, timestamp, and number formats. In the script, they use TO_CHAR to get the desired format.
12c - no changes to the script; now each column is on a separate line. If I set linesize to 10000, I see the expect behavior with a whole lot of whitespace between columns.
I still had copy of this production database that I used to practice the upgrade. I went in and changed the parameter permit_92_wrap_format to false. Behavior reverted back to what we saw in 11g. However, I'm not convinced this is the right workaround.
Has anyone else see this behavior? We have a lot of scripts and changing all of them to use a column alias and column formatting (which should have been done in the first place) would be a major undertaking. I haven't found any bugs on MOS related to this yet or any useful information in the Oracle docs. My co-worker is opening an SR, but no response yet.
Thank you in advance for any guidance.
--
Sandy B.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 13 2017 - 22:13:00 CEST