Format sqltext from v$sqltext

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MAK

    Format sqltext from v$sqltext

    Hello,
    I have a phonebook worth of SQLs fetched from v$sqltext. Its in text
    file. I am tasked to run explain plan on them. They have newlines and
    space characters all over the place.
    Anybody have any script that can be used to format the sql in a format
    so that I can run the explain plans.

    Thanks in advance.

    Mak
Working...