Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Oracle 11g select query with Json field

    I want to fetch data from below table. Table Name: Insight Id | Name | JSON_DATA ----+------------+------------------------------------------------------------- 1 | Sitansu. | {"country_codes": ["IND"], "regions": ["ASIA"]} 2 | Sitansu. | {"country_codes": ["IND","U
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Regarding Oracle Reports (RDF) 10g

    Hello, 1. Could you please confirm if we can use REST API as DATASOURCE for RDF report, to generate the output ? Otherwise, what alternative can be done to store REST API data and then use it for RDF report ? Will Before-Report trigger come into play ? 2. Previously, the RDF repo...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Overloaded Stored Procedure

    We have an overloaded stored procedure with the following declarations in our 3rd party application: PROCEDURE GetPriceInfo (Location IN VARCHAR2, ProductCode IN VARCHAR2, SalePrice OUT NUMBER); PROCEDURE GetPriceInfo (Location IN VARCHAR2, ProductCode IN VARCHAR2, ContractID IN ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Exluding ARCHIVE_MESSAGES tbs from weekly backup

    Hi Tom, In an development Server we want to do a Rman Backup weekly which has the following tablespaces: SYSTEM SYSAUX UNDOTBS1 TEMP USERS IAGENT_DATA ARCHIVE_MESSAGES I want to exclude the ARCHIVE_MESSAGES Tablespace in the weekly backup which has historical Data to save disk ba...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Where can I see a list of API's being called?

    Is there a report that will list the API's being called in a particular environment and their details? If not a report, is there somewhere in the UI? (Screenshots or path would be most appreciated). I don't know much about REST API's other than they are web services used to perfo...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more