MuleSoft Database Insert Tutorial | Insert Data in Oracle Database Using MuleSoft AnyPoint Studio

[@Tjjifar]

How do you design a Mulesoft API for the below requirment? If a data is not found in the Oracle DB then write it the DB. If this data is found in the DB then update the record.

[@PremKumar-nw6ts]

How to create Schema file .xsd? Could you please help me in this?

[@namanmathur1]

Hello. If I want to insert data into 2 tables in Mule Insert and want to use LAST_INSERT_ID of first table into the second table through variable, how can I do that?

[@TutorialsPediaVideos]

Dear Naman, For this, use a Database query to get nextval from a database sequence and use that as primary key in first table and foreign key in second table.