Sorry Mate .. The Woes of using a Tool to Query on ... Anyways U dont have any direct way to do that .. Create another table that has a Clob Datatype and select from that ... Sorry once again .... :) On Thu, 2 Dec 2004 15:35:32 +0530, Abraham Kurian <kurian24@xxxxxxxxx> wrote: > whats this Values_less_than ? > > > > > On Thu, 2 Dec 2004 09:57:51 +0000, Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote: > > Select * from Dba_Tab_Partitions where Values_less_than = '01-DEC-2004' > > > > HTH > > > > Cheers > > Ganesh > > > > > > > > > > On Thu, 2 Dec 2004 14:54:30 +0530, Abraham Kurian <kurian24@xxxxxxxxx> > > wrote: > > > Hi , > > > > > > I have lots of partitioned tables in my schema , the > > > requirement is to identify the current partition of the table. > > > > > > Let me explain this with an eg. > > > > > > Lets say I have a table T , with 24 partitions .. starting for Jan -04 > > > to Dec-05. Now , my current partition is Dec-04. > > > > > > How can I achieve this by querying the data dictionary ? > > > > > > Regards > > > Kurian > > > > > > > > > > > >