Parse SQL Statement using XSL

I have an XML file that contains a SQL Statement inside one of the tags.
I am using FO to 'document' this query XML file.  The problem is, the
SQL statement is not formatted very neat.  I would like to break or
parse it so the output would look something like:

 

SELECT

            A.COL1,

            A.COL2,

            A.COL3 as SOME_COLUMN,

            B.COL1 as B_COL_1,

            B.COL2 as B_COL_2

FROM

            FILE1 A

            FILE2 B

WHERE

            A.COL1 = B.COL1     AND

            A.COL2 = B.COL2

ORDER BY SOME_COLUMN

 

 

Received on Thursday, 2 November 2006 19:09:40 UTC