Hi
I've had a look at the 2 answers mentioned in a previous post.
For the second option, using dbms_rowid, what if I do not know the column name (which in the previous post is ID), but do have the value that the table is partitioned ranged by, (for example date).
Is there a way to identify the partition object in such a case?
I appreciate that using dbms_xmlgen with xmltable will assist in identifying a partition, as is used in this post , however I wanted to know if there was a way to identify the partition using dbms_rowid without having a column name.