Oracle regex expression containing "?" -
Oracle regex expression containing "?" -
i have query uses regex look follows
update user_master set first_name = ? whereuser_id = nvl(regexp_substr(?, '^(\[0-9]+|[0-9]+(\[0-9]*)?)$'), 0) for query execute have available gui interface me can pass required values seperated ,
field_value_1 field_value_2 here got error
count of fields selected not match count of place holders in sql update section here expecting three field values since total number of ? three (two of them place holder , 1 within regex) .
how create functionality intact while ignoring ? within regex
what happens if replace '^(\[0-9]+|[0-9]+(\[0-9]*)?)$' '^(\[0-9]+|[0-9]+(\[0-9]*)' || chr(63) || ')$' ?
it's ugly may way trick badly written gui tool.
regex oracle oracle11g
Comments
Post a Comment