Update and Insert into existing oracle table

Renga3037 · August 2020

Hi All

I have two task to do.

1. I wanna update into existing table in oracle, is there any option to do that ?

2. Then I wanna insert into existing table in oracle, I saw the append instead of overwrite option but how to give the existing table in output ?

Please guide/Suggest the way

Thanks in advance

Liev · August 2020

Hi @Renga3037

UPSERT operations are not graphically supported in DSS, however, you can still carry out these operations if you use a SQL recipe script option, see here for some info on how these work.

Good luck!

Renga3037 · September 2020

@Liev

Thanks for your suggestion.

What about existing table insert ? Any idea !

Liev · September 2020

For task 1 you can use an SQL recipe script type with UPDATE inside.

For task 2 you can use a normal SQL recipe which will compute records and append new records if you have selected Append new records from the Input/Output tab of the recipe.

Or

You could do both in one go using an SQL recipe script type with UPSERT inside.