Format sqltext from v$sqltext
From: MAK <maks70_at_comcast.net>
Date: 10 Jan 2004 00:40:46 -0800
Message-ID: <b7178504.0401100040.3e0648da_at_posting.google.com>
Date: 10 Jan 2004 00:40:46 -0800
Message-ID: <b7178504.0401100040.3e0648da_at_posting.google.com>
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 Received on Sat Jan 10 2004 - 09:40:46 CET