11.2.0.3 : using substr not formatting colums.
Hi,
When I am running a substr command from sqlplus, it does not format columns automatically. However, in another environment, the same command is give me the output as expected.
Example:
select substr(interface_line_context,1,10) contx,
substr(batch_source_name,1,7) batch,
substr(cust_trx_type_name,1,10) trxname
from ra_interface_lines_all
where interface_line_id = 1580025
Output in ENV1
CONTX BATCH
------------------------------ ---------------------
TRXNAME
------------------------------
Global Dat AR Nasc
NASCO PAR
Output in ENV 2
============
CONTX BATCH TRXNAME
---------- ------- ----------
Global Dat AR Nasc NASCO PAR
How do I resolve this
Thanks
Ram
When I am running a substr command from sqlplus, it does not format columns automatically. However, in another environment, the same command is give me the output as expected.
Example:
select substr(interface_line_context,1,10) contx,
substr(batch_source_name,1,7) batch,
substr(cust_trx_type_name,1,10) trxname
from ra_interface_lines_all
where interface_line_id = 1580025
Output in ENV1
CONTX BATCH
------------------------------ ---------------------
TRXNAME
------------------------------
Global Dat AR Nasc
NASCO PAR
Output in ENV 2
============
CONTX BATCH TRXNAME
---------- ------- ----------
Global Dat AR Nasc NASCO PAR
How do I resolve this
Thanks
Ram
0