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

From: Nuno Souto <>
Date: Thu, 11 Mar 2010 23:17:21 +1100
Message-ID: <>

Nuno Souto wrote,on my timestamp of 11/03/2010 10:50 PM:
> 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? ;)

Oh, and of course: if you re-create these two owned by the user that fires off the original SQL instead of owned by SYS, it'll quietly "overload" the SYS definition without affecting other user's SQL.

Nuno Souto
in overcast Sydney, Australia
Received on Thu Mar 11 2010 - 06:17:21 CST

Original text of this message