Re: String search and replace in pl/sql

From: SteveC <stevec_at_sfsu.edu>
Date: 10 Feb 2006 09:53:15 -0800
Message-ID: <1139593995.051690.35850@o13g2000cwo.googlegroups.com>

Unless the SQL always has a single level of nesting as in your example you will probably need to build an elaborate process to parse the SQL statement, even down to looking at paired parentheses.

About the only thing you can be sure of is that each Select will have a
>From clause. Unfortunately the Where and Order By clauses are
optional.

...or maybe just take the entire SQL statement, and wrap it inside this:

Select * from ( [the entire original sql select] ) order by [new order-by clause] Received on Fri Feb 10 2006 - 11:53:15 CST