Update and Insert into existing oracle table

[Renga3037]

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]

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]

@Liev 

Thanks for your suggestion.

What about existing table insert ? Any idea !

[Liev]

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.