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
Explain the use of show option in imp command.
What is oracle update statement with inner join ?
What do you mean by merge in oracle and how can you merge two tables?
What is ceil and floor in oracle?
What is private procedure oracle?
What is an oracle transaction?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is a table index in oracle?
What is a cursor in oracle?
What happens if variable names collide with table/column names?
how do u setup a replication site?
What is using clause and give example?
How many types of segments in Oracle?
What is the quickest way to fetch the data from a table?
What are the types of partitions in oracle?