Does anyone know the proper syntax for extracting XML data using Impromtu?
I can do the following:
select distinct extract(xml, 'path/text()').getStringVal() from TABLE_NAME
When I add a column of a different type to the same SQL, I receive a -239 error. Example:
select distinct Date, extract(xml, 'path/text()').getStringVal() from TABLE_NAME
where Date between to_date('2001-01-01) and to_date(2002-01-01)
Latonya
I can do the following:
select distinct extract(xml, 'path/text()').getStringVal() from TABLE_NAME
When I add a column of a different type to the same SQL, I receive a -239 error. Example:
select distinct Date, extract(xml, 'path/text()').getStringVal() from TABLE_NAME
where Date between to_date('2001-01-01) and to_date(2002-01-01)
Latonya