Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonSQL to find gaps in date ranges
Hi All,I would like to get the gaps between date range and needed it to separate the gaps by MM ID.could you please someone help me to resolve belowINPUT:ID | MM Number | From | To12345|4444444 |2015-01-03 |2015-02-0212346|4444444 |2015-02-03 |201...
Chris SaxonMaterialized view
hi tom,This is with reference to question asked earlier about MV. i don't know how to write the revert against the questions asked.https://asktom.oracle.com/pls/apex/asktom.search?tag=materialized-view-complete-refresh-getting-slowerActually in below pr_fact_x...
Connor McDonaldSelect statement goes with Table Storage full in Dev environment but uses index range scan in SIT environment
Hi Team,I have a same table in 2 environments Development and SIT. Both have the same index pptcode_1_3.Environment - DEVTable name - pptcode number of rows - 103819execution time - 9 secswhen i run execution plan on development it does TABLE ACCESS STORAGE FU...
Connor McDonaldOEM report long running backup
Hello Team,CAN ANYONE PLEASE SUGGEST HOW TO CREATE EMAIL NOTIFICATION OF LONG RUNNING BACKUP JOB REPORT FROM EOM....
Connor McDonaldget someone's age in an APEX field
cordial greetings this is to check if there is a way to automatically obtain an age in a field when the user registered the date of birth...

Resources