471,090 Members | 1,387 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

Format sqltext from v$sqltext

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.

Jul 19 '05 #1
0 2879

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Martin Foster | last post: by
15 posts views Thread by Simon Brooke | last post: by
3 posts views Thread by stevek | last post: by
6 posts views Thread by Dario Di Bella | last post: by
11 posts views Thread by Grumble | last post: by
4 posts views Thread by David Morris | last post: by
13 posts views Thread by Roy | last post: by
reply views Thread by kandiko | last post: by
reply views Thread by MAK | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.