"damorgan" <damorgan_at_exesolutions.com> wrote in message
news:3CAB3224.B907552C_at_exesolutions.com...
>Your comment about temp
> tables, for example. While temp tables are commonly used in TSQL there is
almost
> never a rational reason to use them in Oracle.
I disagree (I think but am willing to be convinced otherwise), temporary
tables are a valid approach to storing data to be manipulated in a
transaction, of course PL/SQL arrays (I insist on calling them arrays cos
thats what they are not tables at all) are another approach. The difference
is of course that with 8i and up they should really be global temporary
tables with the appropriate row presevation clause.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Apr 04 2002 - 02:29:53 CST
