oracle combine constants unparalleled table


in oracle, given rudimentary information table:



create list information (
id varchar2(255),
pivotal varchar2(255),
value varchar2(511));


suppose i wish "insert update" value. i have something like:



merge information controlling twin 
(id='someid' key='testkey')
when matched following
transform set value = 'somevalue'
when matched following
insert (id, key, value) values ('someid', 'testkey', 'somevalue');


is there improved proceed this? management seems have following drawbacks:




  • every verbatim needs typed twice (or total twice around parameter setting)

  • the "using dual" syntax seems hacky



if best way, there any proceed around carrying set any parameter twice jdbc?



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?