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

Popular posts from this blog

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* -

mediawiki - How do I insert tables inside infoboxes on Wikia pages? -

Local Service User Logged into Windows -