Ask The Oracle Mentors

Recently Answered

	SQL 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...
	Materialized 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...
	Select 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...
	OEM report long running backup Hello Team,CAN ANYONE PLEASE SUGGEST HOW TO CREATE EMAIL NOTIFICATION OF LONG RUNNING BACKUP JOB REPORT FROM EOM....
	get 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...