Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kamlee
Starting Member
6 Posts |
 Posted - 2004-08-29 : 04:37:59
|
| Hi,I am using the Database Oracle and need to create some triggers to ensure that the following constraints are not implemented on the scott database.I am very new to this, and am having trouble writing them. The ones need to create, need to satisfy the following criteria:(1)No individual user is allowed to update the products associated with a particular order more than twice(2)No deletions can leave an order without any associated items.(3)Any update or insert into the SALGRADE table has to ensure that salary ranges for each grade do not overlap. Could someone help me with these please, as I am going into this blind.Many thanks |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-08-29 : 05:52:33
|
| SQL Server Forums at SQLTeam.comNot sure if You will have luck with Oracle Triggers !1) You will have to store the information about how many times a particular user has updated the products of an order somewhere.2) This can be done with a Foreign Key relationship, don't think there is a need for a trigger3) Triggerlazydba.com has an oracle section./rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-30 : 08:09:42
|
| Look at www.dbforums.com also. Don't ever subscribe to the www.lazydba.com Oracle email subscriptions. I was getting 15 million emails an hour from that.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Creating Triggers