PL/SQL (MOSC)

MOSC Banner

Disabling all formatting or truncation in SQLplus output

edited Aug 26, 2015 10:13AM in PL/SQL (MOSC) 9 commentsAnswered

In SQLplus I'm entering a select statement on three fields, 2 NUMERIC  and one LONG. The output is formatted and looks truncated. I would like to see the whole

content of the LONG field (which is a zero terminated character string).

Also I would prefer to not have any formatting lines (like =========== =======). How can I achieve this?

Thank you.

--

Christoph

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