Wednesday, December 16, 2020

Aggregate/Sum of child attribute in ADF View Link using Groovy - ADF 12c

Create a new transient attribute in master VO to hold Sum value. Choose below properties


For expression value (yourColumnName is from child VO)








For refresh expression value




Friday, December 11, 2020

how to restore dropped table and data after commit.

 FLASHBACK TABLE <table_name> TO BEFORE DROP;

Find more at link below

https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905.htm