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 can we create the complete backup of data in the oracle.
How to create a new tablespace in oracle?
How to start your 10g xe server from command line?
What is meant by raw datatype?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to invoke the original export import utilities?
How many types of segments in Oracle?
Whether any commands are used for months calculation? If so, what are they?
Does oracle database need java?
Can we create database in oracle using command line ?
What is a proxy object?
How to select an oracle system id (sid)?
What is translate in oracle?
How many memory layers are in the oracle shared pool?
Explain view?