Re: Is possible to return the SQL result but not query the table?

From: Nuno Souto <>
Date: Thu, 11 Mar 2010 22:50:08 +1100
Message-ID: <>

Brooks, Dominic (London)(c) wrote,on my timestamp of 11/03/2010 8:19 PM:

> This SQL's result is not been used anymore, but I can't access the
> program code, so my question is:
> Can I do something in the database side, and tell the database when this
> SQL runs, just return a static result, avoid to querying all_tab_columns
> and all_ind_columns views?

You could be a reeeeeealy baaaaaad boy and re-create the all_tab_columns and all_ind_columns views yourself to be something harmless and fast. But of course that will invalidate any other SQL that might access them. Don't tell support I suggested that, OK? ;)

Nuno Souto
in overcast Sydney, Australia
Received on Thu Mar 11 2010 - 05:50:08 CST

Original text of this message