Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonGetting 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...
Chris SaxonGenerating 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...
Chris SaxonInvalid 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 ...
Connor McDonaldStats_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? ...
Connor McDonaldPartition 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>...