SQL Language (MOSC)

MOSC Banner

11.2.0.3 : using substr not formatting colums.

edited Sep 5, 2013 7:01AM in SQL Language (MOSC) 8 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center