Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Howto Create global temporary table in Oracle 8.0.5

Re: Howto Create global temporary table in Oracle 8.0.5

From: degelis <claudedube_at_gmail.com>
Date: 15 Dec 2005 09:37:40 -0800
Message-ID: <1134668260.765407.302160@g44g2000cwa.googlegroups.com>


Hi James,

I found a way to create temporary table
I use variable-size arrays with multiple dimension

  TYPE ARec IS RECORD (

      a NUMBER,b NUMBER);
  TYPE A IS TABLE OF ARec
  INDEX BY BINARY_INTEGER; That way, I will collect information
on each row deleted and then
I will process the information collected at the end so I dont have warry about
to flush the data.

Thank you very much for time
Claude
ciao ciao Received on Thu Dec 15 2005 - 11:37:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US