If it does not involve too much of volume i would prefer creating an object type, assiging values to it and select CAST from it. HTH GovindanK On Fri, 26 Aug 2005 11:52:23 -0400, "Aggarwal, Meenakshi" <Meenakshi.Aggarwal@xxxxxxxxxxxxx> said: > Does anybody know any reason of not using temporary tables in Oracle 9i. > > Thanks > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l