Dick, I totally agree with your statement about changing the approach from other databases. Maybe I'm missing something here. Oracle 8i introduced Global Temporary Tables and if I'm not mistaken Oracle9i improved the concept. Would this help Gina? http://www.oracle-base.com/articles/8i/TemporaryTables.php Dennis Williams On 11/21/05, Goulet, Dick <DGoulet@xxxxxxxx> wrote: > Gina, > > Regrettably this is one place where Oracle has something to > learn from their open source competition. -- //www.freelists.org/webpage/oracle-l