how to retrive xml data for using sql query?
- 3 Answers
- 5867 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 force the database to use the user specified rollback segment?
Explain the use of indexes option in exp command.
What is meant by joins? List out the types of joins.
What is an oracle table?
Explain the dml?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Explain about functional dependency and its relation with table design?
How to assign a table row to a record variable?
how the indexes are stored in the Oracle Database?
Explain the use of analyse option in exp command.
Explain integrity constraints?
How to compare dates in oracle sql?
How to work with data objects interactively?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain compound trigger in oracle?
