Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: from max date - 7 days

Re: from max date - 7 days

From: joel garry <joel-garry_at_home.com>
Date: Mon, 22 Oct 2007 13:32:56 -0700
Message-ID: <1193085176.188856.180640@e9g2000prf.googlegroups.com>


On Oct 20, 5:40 am, sansar <uemit.uen..._at_googlemail.com> wrote:
> 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

Could it be that putting the dot in makes it look for a schema named part_19? And putting the quotes on protects the partition name from schema translation? Or something like that.

jg

--
@home.com is bogus.
Ad on dizwell blog post about shutting down:
http://h71028.www7.hp.com/enterprise/cache/523434-0-0-0-121.html?jumpid=ex_hphqglobal_disasterproof/disasterproof/google
Received on Mon Oct 22 2007 - 15:32:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US