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
7030 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

Explain the use of show option in imp command.

1112

What is oracle update statement with inner join ?

1074

What do you mean by merge in oracle and how can you merge two tables?

961

What is ceil and floor in oracle?

1080

What is private procedure oracle?

1023

What is an oracle transaction?

1160

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2980

What is a table index in oracle?

1138

What is a cursor in oracle?

1197

What happens if variable names collide with table/column names?

1206

how do u setup a replication site?

1998

What is using clause and give example?

1061

How many types of segments in Oracle?

1088

What is the quickest way to fetch the data from a table?

1072

What are the types of partitions in oracle?

1048