I extract xml from an Oracle Clob in a view using the following type syntax
select col1, col2, dbms_lob.substr( t.col_clob, 4000, 1 )) col_3 from table1 t
I display the columns from the view in a DataWindow.
I want to display the col_3 results to the user. (Yes, they want to see the xml).
The xml being thrown into a text field is not formatted nicely.
Is there a way to format this xml data nicely?
When they click inside the data area - the format gets all messy (they also require to be able to copy and paste from this column).
I rarely work with xml being displayed to a user - was wondering if anyone has suggestions for me.
Any Suggestions Are Greatly Appreciated.
Sheldon