Re: MSSQL Table Variable Equivalent?

On Sun, 04 Dec 2005 02:10:32 -0600,
oleg.kirshon_at_comcast-dot-net.no-spam.invalid (TheKirshons) wrote:

>I'm not being a smart-seat, I'm truly asking.
>
>thx, Oleg.

At the same time you are lazy, while topposting, making this discussion difficult to follow. To respond below the original text only requires hitting ctrl-e. As humans happen to read from top to bottom, you might refrain from topposting in the future.

You seem to be asking whether a table can be hold in memory indefinitely. You might be willing to read up on the keep cache. Better still: you might want to forget about sqlserver at all, and don't try to make Oracle behave like sqlserver. You will end-up in failure.
As to caching a table indefinitely, you can load the table in a PL/SQL collection. Keep in mind however, you won't see any changes to that table anymore. Usually that is reason enough to stick to the normal buffer caching mechanism.

--
Sybrand Bakker, Senior Oracle DBA