Ask The Oracle Mentors

Recently Answered

	Getting Value from JSON array using PL/SQL I need help. I do I get data from the stats object in the JSON array using PL/SQL?<code>{"items": [{" stats": {"m_date": "2019-05-31T00:00:00","v_num": "0040012","pk_num": "0562","amt": 94,"bal": 75,"disc": 13}}}</code>Thanks...
	Generating a random number of rows for every date within a date range I have some working SQL below that generates a row for each employee_id.My goal is to get every date in the range via the function, which works fine standalone, then get N ( random number ( 1-10) of rows for each employee_id for every in the range specified.O...
	Invalid XML character Error - How to find the invalid character from a VARCHAR2 database column? Hello,Oracle newbie here.I am getting this error "Character reference "&#56256" is an invalid XML character" for XML data that is printed onto a report. The XML data that is causing the issue is from a VARCHAR2 data column in the database. I have filtered out ...
	Stats_mode function - Deterministic or Non- Deterministic Stats_mode function - Deterministic or Non- Deterministic? What does Oracle return when there are multiple keys with same mode (highest) and how? ...
	Partition pruning with MEMBER OF operator Hello Tom !Is it possible to force Oracle to use (sub-)partition pruning when MEMBER OF operator is used on some nested table?For example:<code>SELECT * FROM A_TABLE WHERE COL_1 MEMBER OF NUMBER_TAB_TYPE(1,10,4);</code>where NUMBER_TAB_TYPE is defined as<code>...