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>
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,
--
- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
- Mi sitio sobre programación web: http://bits.demogracia.com
- Mi web de humor al baño María: http://www.demogracia.com --