Skip to Main Content

Questions

QuestionUpdatedAsked

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('...
21 hours ago6.3 years ago

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.0023D89006...
21 hours ago4.5 years ago

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 spa...
21 hours ago6.5 years ago

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 indexesevery thing is moved/changed except for the default tablespace of the LOB, i was not a...
21 hours ago4.6 years ago

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 ,...
22 hours ago13.5 years ago

Could you explain me about Key-preserved table conceptin join views.i know that a table is ket preserved if every key of the table can also be a key of result of the join.but i not understand meaning of this.Thanks ...
22 hours ago22.1 years ago

Hi, Tom.I recently saw an answer you gave with respect to creating XML from a SQL query.Here is the code that I copied from your answer.==========================================================create or replace package xml_handler_pack is procedure xml_dat...
40 hours ago19.8 years ago

We have a table called PROTOKOLL, with the following definition:<code> CREATE TABLE "PROTOKOLL" ( "UUID" CHAR(36 BYTE) NOT NULL ENABLE, "VERSIONSNUMMER" VARCHAR2(20 BYTE), "TYP" CHAR(1 BYTE) NOT NULL ENABLE, "BENUTZER_ID" VARCHAR2(250 BYTE) NOT NULL ENA...
40 hours ago4.7 years ago

Tom,I am trying to calculate mean, median, and mode of salary within each department, and display it on all rows (corresponding to the department). It's fine to ignore rows with a null salary. I believe I've got mean and median, but I need help with mode. B...
42 hours ago18.5 years ago

Hi Tom I hit a problem, when gen DDL statement using DDL command in sqlcl tools. Follow with my environment: (1) Redhat (2) Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production(3) SQLcl: Release 4.2.0.17.097.0719 ProductionIn the datab...
2 days ago5.1 years ago

Hi Tom , I am new in tuning sql statements. Can u give a methodology of tuning the sql statements and to predict the output of explain plan.When i use explain plan for a particular query, i am able to understand what the result means. can u pls clarify it for ...
2 days ago22.4 years ago

i use database, Oracle Database 10g Enterprise Edition Release 10.2.0.1.0and i found a java source that gives the mac address of the host, so i wrote it in oracles objects (below from the question)when i write it in eclipse it worksbut when i write it in orac...
2 days ago13.7 years ago

Tom, Have heard DBA's mention everytime to keep the logical reads low. But, when asked why, they can't come with an answer. When a block is requested by a query, Oracle looks for it in the Buffer Cache and if found, it results in a Logical read and if it do...
2 days ago19.8 years ago

Hi, We are running PeopleSoft and ocassionally we get error: ORA-01460: unimplemented or unreasonable conversion requested. There is nothing in the alert.log file and we can move past the error by just restarting the failed process without making any changes...
2 days ago5.7 years ago

Hi, is delayed Data Guard in the roadmap for Autonomous database? I've a customer concerned about ransomeware attacks so they want a time gap on their ADG. They are in Amsterdam and will run Cross region ADG to Frankfurt, but would like to have a possiblity to...
3 days ago3 days ago

Hello1.What is a deadlock and how can i detected, how can i fix a deadlock??2. I've a temp tablespace with 3 GB of size, acording to the high water mark anly have been use about 300 MB of the file, i try to resize to 1.5 Gb but it doesn't let me, why is that??...
3 days ago20.3 years ago

<code>insert /*+ append */ into tselect rownum,mod(rownum,5)from all_objectswhere rownum <=1000call count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- ---------- ---------- ----------Parse...
3 days ago14 years ago

hi TOM,please tell me, what is the opposite for INTERSECT?...
3 days ago5.1 years ago

Tom, I was working with External tables and Oracle came up with an error when I tried to insert, update or delete from external tables, as shown below.SQL> delete from student_ext;delete from student_ext *ERROR at line 1:ORA-30657: operation not su...
3 days ago20.3 years ago

Hi Tom I enjoy reading your site. I learned lot of tricks from your site. I need to write a SQL to group the data in ranges.Below is the dataSite_no tot_rec1001 100001002 200001003 305001004 500001005 250001006 360001007 280001008 21000For every runnin...
3 days ago10.9 years ago