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: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228405 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
