query on xmltype

[rumcool]

Hi,
how to convert xmltype datatype to varchar2, such that it needs
to be passed to utl_file.put_line() ?


thanks in advance

[Srinivas_Sharma]

i think what u wanna do is

xml storage and sql representation

Create a view by using the below functions
extract() and extractValue()

Hope this helps

Srini

[grjohnson]

Originally posted by Srinivas_Sharma
i think what u wanna do is

xml storage and sql representation

Create a view by using the below functions
extract() and extractValue()

Hope this helps

Srini

Hope you enjoy Full table scans