Re: temporary tables in oracle

On Fri, 29 Jan 1999 16:06:26 -0600, Kent Eilers <kent.eilers_at_pca.state.mn.us> wrote:

>I come from sybase/sql-server where we used temp tables instead of
>cursors (big reason: giant performance increase). Do you Oracle gurus
>use temp tables in procedures? I have found little documentation on
>this in two Oracle books I have.
>
>Thanks.

Oracle doesn't work like that.

<begin soapbox>

In general, two products which are based on the relational model and the SQL standard can have no more in common than what is implied by those two things. In practice, they have even less in common, as they were produced by separate teams of implementors following separate imperfect understandings of the relational model and a (sometimes) imperfectly understood SQL standard which is itself a distorted and unnatural view of the relational model.

Furthermore, if the reason you do something in one product is performance, it is very likely that even if another product has the same problem, it will not have the same solution.

<end soapbox>

Regards,

Eric Received on Sat Feb 06 1999 - 11:35:55 CST