SQL Language (MOSC)

MOSC Banner

Need to format data result set into XML.

edited Jun 5, 2012 3:18PM in SQL Language (MOSC) 1 comment
How do you format result set into XML data.  Problem is that column data are elements and not the column name itself.

Here is some sample data:

KEY,DATE,FIELD_SEQ,FIELD_DEF,FIELD_VALUE

1,05-JUN-2012,1,SOME_NAME_1,abcd

1,05-JUN-2012,2,SOME_NAME_2,1234

1.05-JUN-2012,3,SOME_NAME_3,edfg

1,05-JUN-2012,4,SOME_NAME_4,5678

2,05-JUN-2012,1,SOME_NAME_2,abcd

2,05-JUN-2012,2,SOME_NAME_3,1234

2.05-JUN-2012,3,SOME_NAME_4,edfg

2,05-JUN-2012,4,SOME_NAME_5,5678

2,05-JUN-2012,5,SOME_NAME_6,abcd

3,05-JUN-2012,1,SOME_NAME_1,1234

3.05-JUN-2012,2,SOME_NAME_2,edfg

3,05-JUN-2012,3,SOME_NAME_3,5678

4,05-JUN-2012,1,SOME_NAME_1,abcd

4,05-JUN-2012,2,SOME_NAME_2,1234

4.05-JUN-2012,3,SOME_NAME_3,edfg

4,05-JUN-2012,4,SOME_NAME_4,5678

5,05-JUN-2012,1,SOME_NAME_1,abcd

5,05-JUN-2012,2,SOME_NAME_2,1234

5.05-JUN-2012,3,SOME_NAME_3,edfg

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center