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: Tablepartitioning with date-columns...???

Re: Tablepartitioning with date-columns...???

From: Maik <maik_at_z.zgs.de>
Date: Sat, 14 Aug 1999 21:35:14 +0200
Message-ID: <7p4g6o$s6i2@msheas02.msh.de>


I have made the table with a new column 'dayofweek'. But now i have the very difficult problem, that the user must type a select-statement like this:

select * from partitiontable
where ...

    and datum = to_Date('01.08.1999','dd.mm.yyyy')     and dayofweek = 7
/

???????????????????????????????

It's stupid, or not!! Received on Sat Aug 14 1999 - 14:35:14 CDT

Original text of this message

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