SQL*Plus (MOSC)

MOSC Banner

linesize difference in sql (sqlplus)

edited May 3, 2016 5:03AM in SQL*Plus (MOSC) 8 commentsAnswered

th all things seemingly identical (same 12.1.0.2 client and duplicate 12.1.0.2 databases on two different servers), I'm trying to figure out why the length of this SQL output is different on one database versus the other.  I'm connecting from exact same client (even did show all; to make sure settings were identical).  Also, verified this table is identical on both databases as well.  I've advised the programmer too much is left to interpretation and can easily be fixed but for no other reason than curiosity I'd like to know why these outputs are different, lol.

1. DB1

select price_zone,'PRICEZ'||price_zone from price_zone;

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