Fetch table names from query

From: Álvaro G. Vicario <alvaroNOSPAMTHANKS_at_demogracia.com>
Date: Tue, 20 May 2008 13:48:56 +0200
Message-ID: <g0udpv$sb5$1@huron.algomas.org>

Is there any simple way to extract the table names of a given SELECT query without actually running it?

I've implemented a very simple results cache in my PHP application but I'd like to improve it. And one of the key points is finding out what tables a query reads from so I can handle obsolete data. Writing a reliable SQL parser in PHP looks like a hard task and obtaining a full explain plan from the Oracle server looks like an overkill.

Any ideas?

Thank you in advance,


Received on Tue May 20 2008 - 06:48:56 CDT

Original text of this message