Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Help to understand this recursive query

    Hi Tom,I am not able to fully understand below recursive query. Especially, the condition "WHERE POS > 0" and " WHERE POS = 0". my understanding is pos is result of REGEXP_INSTR (STR, '[A-Z][0-9]{5}',1, RN). 1. if the first POS > 0, how could the final conditi
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Getting word count from context text index by joining to indexed rows

    Hello Tom, I would like to be able to roll up a word count (for a WordCloud control in a UI) based on a query ( a spatial query in this case).I have a table as such<code>create table items (id raw(16), text clob, geom sdo_geometry )</code>This table has a full
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Converting CLOBS TO VARCHAR

    Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    How to unload table data to csv file - fastest way for millions of records

    I have a table with 100 million rows. Table size is around 25 GB in the DB.I need to unload this data to a csv file.What is the best fastest way to do this.I was reading about external tables to do this by using CTAS but I dont think there is an option to dire
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    begin_time/end_time in DBA_HIST_SNAPSHOT vs DBA_HIST_SYSMETRIC_SUMMARY vs AWR report

    Hello Connor & Chris :-),I have some confusion about the <b>begin_time/end_time</b> in <b>DBA_HIST_SNAPSHOT</b> vs <b>DBA_HIST_SYSMETRIC_SUMMARY</b> vs <b>AWR report</b>.<code>13:52:22 SYS@emcdb> desc dba_hist_snapshot Name
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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