Find a specific partition without using the ‘where’ clause - 11g

posted Sep 9, 2010, 1:32 PM by Sachchida Ojha

If you ever want to query a partitioned table, and want to reference a specific partition without using the ‘where’ clause (and do not know the partition name), you could use the following syntax:

Select * from dbceo.part_table partition for (to_date(’08-SEP-2010’,’DD-MON-YYYY’)..

 

Comments