Re: Is possible to return the SQL result but not query the table?
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 Mar 2010 23:19:21 +1100
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.
--
Cheers
Nuno Souto
in overcast Sydney, Australia
dbvision@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
