SQL Language (MOSC)

MOSC Banner

ALTER TABLE statement causes generating strange UPDATE statement

edited Jul 11, 2012 5:37AM in SQL Language (MOSC) 15 commentsAnswered ✓
Hi,

i have table PARTICIPANTS with column UPLOADED_ID_PARTICIPANTS_FLAG CHAR(1) NOT NULL. When i try to modify that column to NULL by using

ALTER TABLE PARTICIPANTS MODIFY UPLOADED_ID_PARTICIPANTS_FLAG NULL;

then Oracle generates this update statement (but only on some instances):

UPDATE PARTICIPANTS set UPLOADED_ID_PARTICIPANTS_FLAG = UPLOADED_ID_PARTICIPANTS_FLAG;

This statement causes problem because there is a trigger on table, which fires exception.

Does anybody know why Oracle generates that statement?

Thanks,

R. Kazimir

robert.kazimir@rb.cz

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center