Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JSON generation support in 19.2, not loaded; not able to generate JSON files from ordinary database

William TAug 7 2019 — edited Aug 7 2019

Hello,

I am not able to generate JSON files from ordinary database files on my machine following the rules of json_object generation. I don't find any mention of JSON in the HELP files loaded with SQL DEVELOPER. NO ONLINE examples of that either.....checking the features under TOOLS menu on the there is no JSON module like there is for XML.

I don't think SQL DEVELOPER does not have the JSON generation tools loaded on it, I don't think that they add-on has been written yet for SQL DEVELOPER

Can anyone verify that?????

Comments

SriniVEERAVALLI
Answer
You have to execute only 1 EP for both Incr and Full loads, followed by another custom EP which set the DAC refresh table(W_ETL_REFRESH_DT) column as NULL.
ex:UPDATE W_ETL_REFRESH_DT SET LAST_REFRESH_DT =NULL

You need to schedule the custom ep to run on only Saturdays just before your actual EP start time so that you can have DAC refresh dates are null and follow load would be full load.

You need to create a custom etl mapping so that you can set this.. that might be a command from session or workflow.

If helps pls mark as correct :)

Edited by: Srini VEERAVALLI on Jan 24, 2013 8:22 AM
Marked as Answer by user10920449 · Sep 27 2020
1 - 1

Post Details

Added on Aug 7 2019
#sql-developer
1 comment
92 views