Oracle xml manipulation using Java

Question

Having an Oracle database with a table STUDENT, which has a field STUDEN_NAME, is there a way to retrieve it enclosed in XML tags?

select STUDENT_NAME from STUDENT;

res.getString("STUDENT_NAME"); // I want: <StudenName>PAUL</StudentName>

Thanks

Abra · Accepted Answer · 2018-02-13 10:48:11Z

3

select xmlelement("StudentName", STUDENT_NAME) from STUDENT;

A Google search for

oracle result set as xml

Turned up the Oracle XML DB Developer's Guide, specifically chapter 18, entitled Generating XML Data from the Database - from where I got the syntax shown above.

answered Feb 13, 2018 at 10:48

Abra

21k14 gold badges101 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Abra Over a year ago

Sorry, forgot to add in your java code use: res.getString(1).

M. Prokhorov Over a year ago

no real need. He can just alias the query column and still use the name.

JLLMNCHR Over a year ago

rs.getString("STUDEN_NAME"); and rs.getString(1); returns null (but the table contains names) ¿?

Visionary Zen · Accepted Answer · 2018-02-13 10:50:46Z

1

If you mean that you want to make the actual change in the query then the following will give you what you are looking for:

SELECT XMLELEMENT("StudentName",student_name) student_name FROM student;

answered Feb 13, 2018 at 10:50

Visionary Zen

801 silver badge6 bronze badges

Comments

JLLMNCHR · Accepted Answer · 2018-02-13 12:28:05Z

0

The solution for me comes using getClobVal;

select XMLELEMENT("StudentName", STUDENT_NAME).getClobVal() STUDENT_NAME from STUDENT

answered Feb 13, 2018 at 12:28

JLLMNCHR

1,6196 gold badges31 silver badges58 bronze badges

Collectives™ on Stack Overflow

Oracle xml manipulation using Java

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related