RE: Script to Disable Constraint, Change Value, then Enable Const

EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 1:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Script to Disable Constraint, Change Value, then Enable Const Rick, thanks for your input.  When I test the deferred constraint in SQL*Plus I get an error.  What am I doi

RE: Script to Disable Constraint, Change Value, then Enable Const

computer.  Thank you.   -Original Message- From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const   David,   You need a semi

RE: Script to Disable Constraint, Change Value, then Enable Const

omputer.  Thank you.   -Original Message-From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 12:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Script to Disable Constraint, Change Value, then Enable Const   I have

RE: Script to Disable Constraint, Change Value, then Enable Const

28, 2001 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const   I have had the same type of requirement and decided to use deferrable constraints. Works great!   Rick -Original Message- From: Igor Neyman [mailto

RE: Script to Disable Constraint, Change Value, then Enable Const

ts of list ORACLE-L Sent: Wednesday, November 28, 2001 11:24 AM Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I can see the confusion here.  The point is not to let someone enter data that would violate the refere

Re: Script to Disable Constraint, Change Value, then Enable Const

As far as I remember, there is such a script at http://www.oriole.com, in the X-rated section - as the name implies, not full-heartedly recommended. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts

RE: Script to Disable Constraint, Change Value, then Enable Const

David Wagoner al.com> cc: Sent by: rootSubject: RE: Script to Disable Constraint,

Re: Script to Disable Constraint, Change Value, then Enable Const

AM Subject: RE: Script to Disable Constraint, Change Value, then Enable Const I can see the confusion here.  The point is not to let someone enter data that would violate the referential integrity.  Let me explain with an example:   1.    User wants to upd

RE: Script to Disable Constraint, Change Value, then Enable Const

I can see the confusion here.  The point is not to let someone enter data that would violate the referential integrity.  Let me explain with an example:   1.    User wants to update a primary key record in parent table 2.    Dependent data exists in a child table so the user g

RE: Script to Disable Constraint, Change Value, then Enable Const

Well said Mark. David, you could also re-able the constraint 'novalidate' if you wanted to ignore the validity of any new input. If that was the case then why have an integrity constraint in the first place?   John -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]