Database Administration (MOSC)

MOSC Banner

How do I format SQL_TEXT column, so that it looks easier to read

edited Jan 23, 2024 5:08PM in Database Administration (MOSC) 4 commentsAnswered ✓

How to format below query, so that I can read it more easily?

Output looks like blocky and ugly and hard to read, see below


Thanks


set long 1000
set pagesize 1000

select SQL_TEXT fulltext
from gv$sqltext
where sql_id='a62n9h8a50yrq'
and address = '0000000BCA6E8848'
and hash_value = '340818678'
order by PIECE;


Output


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