How do I format SQL_TEXT column, so that it looks easier to read
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
0