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