Skip to Main Content
Ask The Oracle Mentors
Ask a Question
Recently Answered 2.0
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
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...
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 ...
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...
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...
Upcoming Office Hours
All Office Hours
Upcoming Office Hours Cards
Free training, how-tos and Q&A with Oracle experts, every month!