Simple UPDATE Statement

Asked Sep 09 '13 at 09:06

Active Sep 09 '13 at 09:06

Viewed 46 times

I have a simple oracle statement, and I don't see why it won't work.

UPDATE sdg_user,sdg
SET sdg_user.U_START_DATE = trunc(sysdate-2,'DD')
WHERE sdg_user.SDG_ID = sdg.SDG_ID
and sdg.name in('875933','873401','875946','876036','876103','876271','876274','876297','876298')

asked Sep 09 '13 at 09:06

Ferry Jongmans

my final goal is to set my U_START_DATE to sysdate-2 from SDG_USER – Ferry Jongmans Sep 09 '13 at 09:09
What is the error you are getting? – Prahalad Gaggar Sep 09 '13 at 09:32

Simple UPDATE Statement

0 Answers0