I've not really had much need to use temp tables. So, I don't know a lot about them. But, they're either session or transaction specific (depending on how you create them).
Are you doing something in PL/SQL? Cause there's also pl/sql tables that you could look into. There's also materialized and regular views that might do what you're looking for, depending on what you're trying to accomplish. (You never did answer that "what are you trying to accomplish?" question.) -d On 2/20/07, Russel Madere <[EMAIL PROTECTED]> wrote: > So Oracle Temp tables are similar to ANSI standard SQL cursors. Do the temp > tables continue to exist, empty, between sessions or transactions? Or do > they need to be created at the start of each session or transaction? > > >Ah, yah, you don't want a cursor, then - if you want to select from it > >again like that, you probably want a temp table. Here's some info > >about those: > > > >http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg03sch.htm#7794 > > > > > >On 2/20/07, Russel Madere <[EMAIL PROTECTED]> wrote: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228406 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
