Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > Fetch table nam...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 6907 of 7280
Post > Topic >>

Fetch table names from query

by =?ISO-8859-1?Q?=22=C1lvaro_G=2E_Vicario=22?= May 20, 2008 at 01:48 PM

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
--
 




 8 Posts in Topic:
Fetch table names from query
=?ISO-8859-1?Q?=22=C1lvar  2008-05-20 13:48:56 
Re: Fetch table names from query
DA Morgan <damorgan@[E  2008-05-21 09:25:55 
Re: Fetch table names from query
tool@[EMAIL PROTECTED] (  2008-05-21 18:59:02 
Re: Fetch table names from query
=?ISO-8859-1?Q?=22=C1lvar  2008-05-22 10:11:14 
Re: Fetch table names from query
"Shakespeare" &  2008-05-22 10:31:28 
Re: Fetch table names from query
=?ISO-8859-1?Q?=22=C1lvar  2008-05-22 11:24:08 
Re: Fetch table names from query
Frank van Bortel <fran  2008-05-24 14:59:35 
Re: Fetch table names from query
DA Morgan <damorgan@[E  2008-05-22 11:48:22 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 0:08:24 CST 2008.