SET VERIFY OFF SET ECHO OFF SET PAGES 0 SET LONG 100000 SET lONGCHUNKSI

how to retrive xml data for using sql query?

Question Posted / ksonga

3 Answers
7009 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

Please Help Members By Posting Answers For Below Questions

How can we create the complete backup of data in the oracle.

2161

How to create a new tablespace in oracle?

987

How to start your 10g xe server from command line?

1073

What is meant by raw datatype?

1060

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

2187

How to invoke the original export import utilities?

1064

How many types of segments in Oracle?

1070

Whether any commands are used for months calculation? If so, what are they?

1097

Does oracle database need java?

1011

Can we create database in oracle using command line ?

1088

What is a proxy object?

1063

How to select an oracle system id (sid)?

1064

What is translate in oracle?

1100

How many memory layers are in the oracle shared pool?

1184

Explain view?

1036