Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    How to validate the XML data exists in the XML table

    Hi Tom, Can you please help me on how to validate the XML data available in the XML table. I have one XML table as: CREATE TABLE TEST_XML OF XMLTYPE XMLTYPE STORE AS SECUREFILE BINARY XML; And the data as: INSERT INTO TEST_XML VALUES( xmltype(bfilename('TESTING','TEST_F
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to force Oracle to run a subquery only once

    Hi, I have some behaviour that I don't understand. I have built a call to a custom function in to a sql statement. The function returns a string that I want to use in an insert statement. The string is the concatenation of two bits of information e.g. 0023D89006044013D349510790BF...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    what is the difference between shrink ,move and impdp

    Hi: I want to clean some space about some tables ,there are a few ways ,such as move ,shrink and impdp. I want to know which one is better regardless of space consideration and assume this tables can use all those methods. Can you answer my question from space ,speed and complex ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    changing default tablespace of LOB in a partitioned table

    Hi, I want to move a Partitioned table having LOB to a different tablespace, I have moved all data,indexes and partitions, and set the default tablespace for table and indexes every thing is moved/changed except for the default tablespace of the LOB, i was not able to find the pr...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Drawbacks of queries having many "selects" within the main Select clause

    Hello Tom, I have to tune some queries that are written as shown in the example below: select (select ....) as "col1", col_2, col_3, (select ....) as "col_4", (select ....) as "col_5", from (select (select...), a,b, ...) ,table_1 ,table_2 etc...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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