Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Degree of Parallelism PARALLEL vs. PARALLEL (AUTO) Definition and Calculation 19c EE

    I have two questions both referring to the documentation in Oracle 19c SQL Language Reference PARALLEL hint "For a statement-level PARALLEL hint" section. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Comments.html#GUID-D25225CE-2DCE-4D9F-8E82-401839690A6E 1...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    TIME OF ENTRY IN FORM IF RECORD ADDED IN MASTER LIST NOT REFRESH

    1) I created Employee master FORM from emp table 2) In employee form deptno is the select list and I put button for new department add. It will call dept page form which has property chained = false 3) After adding new dept control goes back to employee form but I can find newly ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    External table in a PL/SQL procedure

    Hi Tom – My task: move several dozen text file imports from SQLLDR (on AIX) into callable PL/SQL procedures. The text files are static in structure with daily refreshes of the contents. The contents are loaded into individual tables in our 19c EE database. The solution appeared t...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Index on XMLTYPE with XPATH Expression including a XPATH Function

    Is there a way to create a index for a xpath that is including a xpath function? Please consider that xmltype index creation fails at oracle livesql.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Exporting a table that contains a CLOB column

    Hi Ask-Tom-team, What is the recommended way for exporting a table that contains a CLOB column to a SQL script? The standard feature of the SQL Developer only exports all columns that are not CLOBs. I want to export the table to a SQL script for including it in the installation o...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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