Is there a misterious way to know if other users has records in a temporary table?

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Tue, 16 Jun 2015 11:48:16 -0400
Message-ID: <CAGYrQytxDwiCLR4Nm7xBY97jZuPT+GNQA4B+--uB6Vz8eGThPw_at_mail.gmail.com>

The reason is because I want to cache in standard edition the results of some procedures, for performance.

but if I modify the source tables, I need to invalidate that values, this means

procedure test

 (*)validate the source data was not modified.

  select from memory result for procedure test.

 when no data_found

    obtaing test result
   insert into memory result.

end;

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 16 2015 - 17:48:16 CEST