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
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