SQLPlus Change

CHANGE Command Syntax:

C[HANGE] sepchar old [sepchar [new [sepchar]]]

CHANGE Command Examples:

3* WHERE offer_status IS IN (‘ACTIVE’, ‘EXPIRED’)
CHANGE /ACTIVE/NO_ACTIVE/

3* WHERE offer_status IS IN (‘NO_ACTIVE’)
CHANGE /(…)/(‘YES_ACTIVE’)/