Use ALTER STEP to modify the command expression in an existing step.

Let’s change Step 1 to call Lowercase() instead of Uppercase().

1 SQL> alter step s_get_month_period_type as (set v_month_pt_name = select name from xactly.xc_period_type where Lowercase(name) like ‘mon%’);