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

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...

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 ...

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...

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...