SQL Language (MOSC)

MOSC Banner

Update Command Error

edited Nov 8, 2019 10:28AM in SQL Language (MOSC) 7 commentsAnswered ✓

OS:  RHEL 6.10

DB: Oracle 11.2.0.3.0, RAC 2 Nodes

Problem:   I am running following update query but getting errors. Any help would be appreciated.  I need to run update on dozens of accounts, do I run commit once after all the updates are done or after every update is run?

update account set active_flag = 'N', status = 'deletionStart' where NUM_REF IN

(‘abc14249’,‘abc99905',‘abc37465’,‘abc64922’,‘abc69824’

‘abc48641’,‘abc37541’,‘abc12357’,‘abc79173’,‘abc15984');

ERROR:

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