Re: MERGE SQL in cx_Oracle executemany

2020-10-18 Thread Peter J. Holzer
On 2020-10-18 06:35:03 -, Mladen Gogala via Python-list wrote: > On Sat, 17 Oct 2020 21:23:40 -0600, Jason Friedman wrote: > >> I'm looking to insert values into an oracle table (my_table) using the > >> query below. The insert query works when the PROJECT is not NULL/empty > >> (""). However w

Re: MERGE SQL in cx_Oracle executemany

2020-10-17 Thread Mladen Gogala via Python-list
On Sat, 17 Oct 2020 21:23:40 -0600, Jason Friedman wrote: >> I'm looking to insert values into an oracle table (my_table) using the >> query below. The insert query works when the PROJECT is not NULL/empty >> (""). However when PROJECT is an empty string(''), the query creates a >> new duplicate

Re: MERGE SQL in cx_Oracle executemany

2020-10-17 Thread Jason Friedman
> > I'm looking to insert values into an oracle table (my_table) using the > query below. The insert query works when the PROJECT is not NULL/empty > (""). However when PROJECT is an empty string(''), the query creates a new > duplicate row every time the code is executed (with project value > popu

MERGE SQL in cx_Oracle executemany

2020-10-12 Thread Naveen Roy Vikkram
Hi there, I'm looking to insert values into an oracle table (my_table) using the query below. The insert query works when the PROJECT is not NULL/empty (""). However when PROJECT is an empty string(''), the query creates a new duplicate row every time the code is executed (with project value po