Well, the regular way how to do that is :
upsert into TABLE (pk1, pk2, pk3, column_to_change) select pk1, pk2, pk3,
'new_value' from TABLE where ...
So you have to provide ALL columns for PK.
Thanks,
Sergey
On Mon, Nov 6, 2017 at 8:04 AM, Adi Kadimetla wrote:
> Hi Team,
>
> I need help to upd
Hi Team,
I need help to update cache_size in SYSTEM."SEQUENCE" for a
SEQUENCE_NAME. I tried below upsert command but there is no upsert syntax
with where clause.
upsert into SYSTEM."SEQUENCE"(CACHE_SIZE) VALUES(0) where
SEQUENCE_NAME='SUBSCRIPTION_SEQUENCE'
Thanks
