Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Partitioning question

    Let's say we have a table of documents with key of doc_id. This table contains millions of documents(rows). There is also a table that assigns one or more industry codes to each doc:create table doc_ind( doc_id integer, ind_code varchar2(10))This ta
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Serializable Transaction

    Hi Tom,On page 130-131 of your book, "expert one-on-one Oracle," you gave an example of two sessions querying and inserting into tables a and b. The result is that both tables contain a row with the value zero in them. My question is that wouldn't the result
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Intermittent Ora-06502: PL/SQL: numeric or value error - For Update Skip locked

    Hi Tom,We are getting Intermittent Ora-06502: PL/SQL: numeric or value error - For Update Skip locked. This error occurs only when application (.Net) calls this SP and it occurs at last pending row from table. But we are able to execute same SP from TOAD succe
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    CloneDB procedure is not working after upgrade form 12.1.0.2 to 19.8

    Hi Ask Tom team,Do you have any information that CloneDB is not working anymore in 18c or 19c.I already have MOS-SR (SR 3-25408180791) open since march this year. First without any additional answers they told me that this is a bug (BUG 32087287 - ORA-17515
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    CONNECT BY basics

    hi tomcan u explain me in detail about "start with connect by" sql statement (tree structure).i know there is documentatin but it is very confusing.
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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