8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for JSON_TABLE Enhancements in Oracle Database 18c


Joaquín González said...

Hi,

There's no need of materialized view log for a "refresh on statement" mview.

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/refreshing-materialized-views.html#GUID-C40C225A-8328-44D5-AE90-9078C2C773EA

Great post!

Regards,
Joaquín González

Tim... said...

Hi.

Force of habit. :) I've removed that now. Thanks for the heads-up. :)

Cheers

Tim...

Viacheslav Andzhich said...

Hi Tim,

Looks like you still reference log in the step description, thus it seems confusing a bit :)

"Create a materialized view log and materialized view using the ON STATEMENT clause"

Tim... said...

Hi.

LOL. Corrected now. Thanks. :)

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.