Update and Insert into existing oracle table

Renga3037
Renga3037 Registered Posts: 9 ✭✭✭✭

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

Answers

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭

    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
    Renga3037 Registered Posts: 9 ✭✭✭✭

    @Liev

    Thanks for your suggestion.

    What about existing table insert ? Any idea !

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭

    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.

Setup Info
    Tags
      Help me…