On 20 Okt., 10:17, William Robertson <williamr2..._at_googlemail.com>
wrote:
> On Oct 19, 12:10 pm, sansar <uemit.uen..._at_googlemail.com> wrote:
>
>
>
> > On 19 Okt., 11:39, sansar <uemit.uen..._at_googlemail.com> wrote:
>
> > > hallo !
> > > can me somebody say, how i get from this select statement max date - 7
> > > days.
>
> > > select max(to_date(substr(PARTITION_NAME,6,10),'dd.mm.yyyy')) from
> > > dba_tab_partitions
> > > where table_name='FRONTEND_TAB'
>
> > > thank you
>
> > > Oracle info: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit
> > > Production
>
> > select max(to_date(substr(PARTITION_NAME,6,10),'dd.mm.yyyy')) - 7 from
> > dba_tab_partitions
>
> > where table_name='FRONTEND_TAB';
>
> Can you give an example of some partition names? I'm surprised they
> have dots in them.
>
> Can you be sure the names will always match the expected format? Looks
> a rather fragile approach to me.
the partition name is:
for example= "part_19.10.2007"
when i give "" to the partitio names, that makes don't problems.
Received on Sat Oct 20 2007 - 07:40:27 CDT
