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