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