Re: Avoiding "ORA-04091". Design Altenratives?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Tue, 4 Nov 2003 17:06:14 +0100
Message-ID: <bo8ipn$f51$1@news.fujitsu-siemens.com>

"Carlo Sirna" <carlo.sirna_at_digisoft.it> schrieb im Newsbeitrag news:bo8hqt$1bf0e4$1_at_ID-135096.news.uni-berlin.de...
> > > Carlo Sirna wrote:
>
> > >> create table mytab
> > >> (
> > >> startdate date not null,
> > >> enddate date not null
> > >> )
>
> > >> I don't want this table to contain overlapping intervals: it must
> be
> > >> impossible to insert a record that overlaps with an already
> existing
> > >> one or to update an existing record in order to make it overlap
> over
> > >> onto another one.

Is it feasible to have one record per day and some group id for each group of days belonging to the same interval?

Lots of Greetings!
Volker Received on Tue Nov 04 2003 - 10:06:14 CST