Re: Tablepartitioning with date-columns...???
From: Maik <maik_at_z.zgs.de>
Date: 1999/08/14
Message-ID: <7p4g6o$s6i2_at_msheas02.msh.de>#1/1
It's stupid, or not!! Received on Sat Aug 14 1999 - 00:00:00 CEST
Date: 1999/08/14
Message-ID: <7p4g6o$s6i2_at_msheas02.msh.de>#1/1
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 - 00:00:00 CEST