PL/SQL (MOSC)

MOSC Banner

Creating triggers and filtering the data

edited Jul 18, 2020 5:00AM in PL/SQL (MOSC) 11 commentsAnswered

Hi Team,

We have profile purchases for different subscribers,Every one hour we need to generate JSON and compare the purchases if there are any updates.

So to minimize the JSON generation and regeneration for the content comparison on the JSON files,We wanted to implement the triggers,In this context

1)JSON generation we will do though PL SQL routine

as per the dig,We want to configure the triggers and based on the updates we will copy staging table and then based on the UENS we will compare the content

Do we need single staging table for all triggers?OR multiple tables?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center