Hi there @! Puzzle @! 2 Systems Dev/Prod Aix 7.1/EE12.1.02. Identical enviroment settings, nls ins

SELECT 'sql' || 'res', trim(to_char(0,'fm9990')), 'a' FROM DUAL;

Prod.

 

Test.

diff on sqlplus settings.

bash-3.00$ diff 1.f 2.f

32,33c32,33

< linesize 100

< lno 5

---

> linesize 80

> lno 14

44c44

< pagesize 10000

---

> pagesize 14

46c46

< pno 1

---

> pno 0

bash-3.00$

glogin is empty.

enviroment profiles are the same.

terminal is the same

nls settings are the same for inst/db/ses

WHY the output is different on two systems ?

SELECT 'sql' || 'res', trim(to_char(0)), 'a' FROM DUAL;

K.