Hi,

if you only need to distinct between the partitions you may use the build
in function DBMS_MVIEW.PMARKER

something like ?

select DBMS_MVIEW.PMARKER(rowid), max(column), min(column)
from your_table
group by DBMS_MVIEW.PMARKER(rowid);

To identify the partition use additional max(partition_key_column) or
max(some transformation of the partition key column) dependent of your
partitioning schema.

Regards,

Jaromir


> Hi,
>
> can we use order by or group by on clause on partition?
.com/go/onm00200636ave/direct/01/
>



--
http://www.freelists.org/webpage/oracle-l