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 truncate in oracle?
Explain do view contain data?
How index is implemented in oracle database?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Is oracle a language?
Explain oracle’s system global area (sga).
What is the difference between alert log file and tarce file ?
What is connection pooling in oracle?
What privilege is needed for a user to connect to oracle server?
List out the components of logical database structure of oracle database.
What is catalog in Oracle?
How to execute a stored procedure in oracle?
How to convert characters to dates in oracle?
How do I spool in oracle?
Can you tell me how to add new column in existing views?how?How is possible?