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
6994 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 truncate in oracle?

960

Explain do view contain data?

996

How index is implemented in oracle database?

999

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1008

Is oracle a language?

934

Explain oracle’s system global area (sga).

1134

What is the difference between alert log file and tarce file ?

2164

What is connection pooling in oracle?

963

What privilege is needed for a user to connect to oracle server?

987

List out the components of logical database structure of oracle database.

1028

What is catalog in Oracle?

1351

How to execute a stored procedure in oracle?

1076

How to convert characters to dates in oracle?

1090

How do I spool in oracle?

998

Can you tell me how to add new column in existing views?how?How is possible?

1432