"Kin Ng" <kin_ng5_at_yahoo.com> wrote in message
news:d5b3f600.0307121142.3465010_at_posting.google.com...
> I have a need to create a temp table for a session only. The temp
> table's structure is not fixed. Thus the current Oracle temp session
> table won't work.
Well you can create tables using dynamic SQL but if you don't intend to
store this data in permanent tables, then I would have thought that an array
(PL/SQL table ) would do you fine. If you do intend to permanently store the
data (and if you don't why are you using an RDBMS) then make sure you get an
appropriate ER diagram done and the appropriate structure should fall out.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Jul 14 2003 - 03:02:08 CDT
