Home » SQL & PL/SQL » SQL & PL/SQL » Oracle_XML (10g)
Oracle_XML [message #402900] Wed, 13 May 2009 00:45 Go to next message
madhavi babburi
Messages: 117
Registered: May 2009
Location: Hyderabad
Senior Member
I write one SQL Query to retrieve data from a table having XMLTYPE with 13000 records. But the query takes more time for execution. Can you tell me the solution to increase the performance. The query is

select d.deptno,d.dname, a.BranchID, x.Empno, x.EName,x.Designation, x.DOJ, x.Salary, x.H, x.Street, x.City, x.State,
x.Country, x.Phno, x.Email
from department d, Employee a, xmltable('for $i in $EmpDetails
return $i/Employees/Emp'
passing a.EmpDetails as "EmpDetails"
columns Empno NUMBER path '/Emp/Empno'
,EName varchar2(45) path '/Emp/Ename'
,Designation VARCHAR2(25) path '/Emp/Designation'
,DOJ VARCHAR2(Cool path '/Emp/DOJ'
,Salary NUMBER path '/Emp/Salary'
,H VARCHAR2(25) path '/Emp/Address/H.NO'
,Street varchar2(25) path '/Emp/Address/Street'
,City varchar2(25) path '/Emp/Address/City'
,State varchar2(25) path '/Emp/Address/State'
,Country varchar2(25) path '/Emp/Address/Country'
,Phno varchar2(25) path '/Emp/Address/Phno'
,Email varchar2(25) path '/Emp/Address/Email'
) x where x.city = 'Mumbai' and d.deptno = a.deptno and x.Designation = 'Jr.Executive';

Re: Oracle_XML [message #402905 is a reply to message #402900] Wed, 13 May 2009 01:09 Go to previous message
Michel Cadot
Messages: 64722
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topic:
Michel Cadot wrote on Tue, 12 May 2009 11:02
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format, use code tags.
Use the "Preview Message" button to verify.


Previous Topic: ANY keywork doesn't work with LIKE?? (merged)
Next Topic: HOw to find out the procedure/Function/Package parmater having default vlaue used
Goto Forum:

Current Time: Tue Apr 25 13:32:10 CDT 2017

Total time taken to generate the page: 0.07438 seconds