If the old and new data are both intended to be valid
- why do you need to disable the constraint?
If its a referential integrity issue - maybe a
deferrable constraint (8.0+) is what you are after.
hth
connor
--- David Wagoner <[EMAIL PROTECTED]>
wrote: > Listers,
>
> Does anyone have a scri
info?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: 27
November 2001 21:30To: Multiple recipients of list
ORACLE-LSubject: Script to Disable Constraint, Change Value, then
Enable Constrain
Listers,
Does
anyone have a script
Listers,
Does anyone have a script that will do the following:
Accept
user input for old data value
Accept
user input for new data value
Disable
table constraint
Update
record with new data value
Enable
constraint
A script like this would help ens