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

grails record upload problems

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

how i emanate permitted url asp.net mvc?