Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Skip ora-00001 and continue?

DavidNilsJan 29 2008 — edited Jan 29 2008
Hi,

I need to perform an update on a table like this:

update myTable
set myColumn = ltrim(myColumn, '0'); --trim all leading zeros

I wnat this to perform on every row where it does not conflict with my unique constraint. I do not want to disable the constrataint because then I will end up with dupplicate records.

Is it possible to create a script where the query executes on all rows where it does not conflict with any constrain? ...and simpy skip the confliction-rows?

Thanks!

(Oracle 10g)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2008
Added on Jan 29 2008
9 comments
436 views