Try this
Select count(*) from dba_tab_privs where privilege='SELE CT' and grantee='<rolen ame>'
premkumar sp
Last Activity: Jan 31 '15, 03:08 AM
Joined: Nov 17 '10
Location:
-
Is the sql query not possible by using xml functions like xmlelement,xmlq uery?Leave a comment:
-
How to fetch data from oracle in xml format?
These are my emp table records
EmpId EmpName
1 AAA
2 CCC
3 BBB
I want to generate xml in below format.
<emp>
<1>AAA</1>
<2>CCC</2>
<3>BBB</3>
</emp>
What is the required sql query? -
Hi
I Have a doubt.
These are my emp table records
EmpId EmpName
1 AAA
2 BBB
3 CCC
I want to generate xml in below format.
<emp>
<1>AAA</1>
<2>BBB</2>
<3>CCC</3>
</emp>
Can you kindly help me?Leave a comment:
No activity results to display
Leave a comment: