(Note: catching up on a severe list backlog, thought I'd complete this
thread for the archives)
Brian -
In case Boris never sent anything directly, I'll extend his example and
show a solution. The usual problem w/ namespaces is getting your head
wrapped around the fact that they're local aliases:
Boris,
Can you send me your final solution?
I am trying to do something similar and I think I am stuck at the namespace.
Thanks
On Mon, Sep 19, 2011 at 11:49 AM, boris wrote:
> On 09/19/2011 10:49 AM, Rob Sargent wrote:
>>
>> Having a name space in the doc requires it's usage in the query.
>
>
On 09/19/2011 10:49 AM, Rob Sargent wrote:
Having a name space in the doc requires it's usage in the query.
yeah, I got it... I was using wrong one...
thanks.
On 09/17/2011 11:48 AM, boris wrote:
hi all,
I've inserted xml file :
http://www.w3.org/2001/XMLSchema-instance";>
zz
Having a name space in the doc requires it's usage in the query.
On 09/17/2011 11:48 AM, boris wrote:
> hi all,
> I've inserted xml file :
>
>
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
>
> zz
> ..
>
>
> to a table:
>
> CREATE TABLE "temp".tempxml
hi all,
I've inserted xml file :
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
zz
..
to a table:
CREATE TABLE "temp".tempxml
(
record xml
)
I can get it using:
select * from temp.tempxml
but, I can't get any values using xpath. ex:
