Quoting William Goedicke <[EMAIL PROTECTED]>: > Dear Y'all - > > I've got a problem wherein I need to derive a table-loading sequence > that is dependent on views. It's relative to a canned application, > PeopleSoft, so I can't change the views in any way. > > My question is does DBI or the Oracle DBD provide any mechanism to > extract the names of all the source tables from the SQL text that > generates the view.
Not sure about generating the source text, but there's a new experimental table_info() member n DBI that may help. As to views specifically, I don't know but I'm guessing that querying the metadata tables would be helpful here. -- Jeff <[EMAIL PROTECTED]> _______________________________________________ Boston-pm mailing list [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm