Ian >I'll be raising a tar as soon as Metalink sorts itself out but I thought >I'd share this as I'm not sure I can 100% trust the results of any >select statement on 10.2 IMHO this is no peculiarity of 10.2. In fact the section "Wrong Results" of *any* note describing the bugs fixed in a patch is quite long! E.g. for 10.1.0.5 about 100 bugs are referenced... Just my 2 cents, Chris -- //www.freelists.org/webpage/oracle-l