how to retrive xml data for using sql query?
Answer Posted / ksonga
SET VERIFY OFF
SET ECHO OFF
SET PAGES 0
SET LONG 100000
SET lONGCHUNKSIZE 10000
SET LINESIZE 200
select dbms_xmlgen.getxml('select * from emp') from dual
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do you store pictures in a database?
List out the types of joins.
How to drop an existing table in oracle?
What is a user role in oracle?
What are the uses of a database trigger?
How do I limit the number of oracle database connections generated by weblogic server?
What are the differences between interval year to month and interval day to second?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Can I create users through internet explorer in oracle 10g?
What is a oracle database?
What is the recommended interval at which to run statspack snapshots, and why?
How to initialize variables with default values?
Can we write insert statement in function in oracle?
What are the set operators union, union all, minus & intersect meant to do?
master table and child table performances and comparisons in Oracle ?