Dear Paul - 

"Newell, Paul" <[EMAIL PROTECTED]> writes:

> There is a view called all_views on our version of Oracle. The description
> for a view appears to be in the TEXT column.

Yeah, that's where I get the SQL statements I'm trying to parse.  The
problem I have is that the statements (there are many, many, many of
them) have multiple layers of sub-selects and I'm trying to extract
*all* the table names.  SQL::Statement seems like it would be perfect,
but it can't parse some of the TEXT.

     Yours -      Billy

============================================================
     William Goedicke     [EMAIL PROTECTED]            
                          http://www.goedsole.com:8080      
============================================================

          Lest we forget:

It's the little things
_______________________________________________
Boston-pm mailing list
[EMAIL PROTECTED]
http://mail.pm.org/mailman/listinfo/boston-pm

Reply via email to