Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Format sqltext from v$sqltext

Format sqltext from v$sqltext

From: MAK <maks70_at_comcast.net>
Date: 10 Jan 2004 00:40:46 -0800
Message-ID: <b7178504.0401100040.3e0648da@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 - 02:40:46 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US