Scheduling Table
From: Glenn Griffith <gagriff_at_bellsouth.net>
Date: Mon, 12 Jul 1999 09:59:21 -0400
Message-ID: <3789F4B8.9C817B84_at_bellsouth.net>
I'm looking for help with a scheduling table. I have a table which is used to schedule events. It consists of the following columns:
Date: Mon, 12 Jul 1999 09:59:21 -0400
Message-ID: <3789F4B8.9C817B84_at_bellsouth.net>
I'm looking for help with a scheduling table. I have a table which is used to schedule events. It consists of the following columns:
ID NUMBER, -- unique identifier Start_Time DATE, -- Date and time the event starts Duration NUMBER, -- How long in minutes does the event last Reserved CHAR -- Y/N column determines if the event can be moved
I want to write a PL/SQL procedure which will insert a new event into the table. Any events that occur after the new event must be pushed and given new times. The insert cannot push any events which are marked Reserved='N'. All non-reserved evenst (Reserved='Y') must be pushed around the Reserved events. Any ideas? Received on Mon Jul 12 1999 - 15:59:21 CEST