Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with XMLType attribibutes? please confirm

Re: Problem with XMLType attribibutes? please confirm

From: Ko van der Sloot <Ko.vanderSloot_at_uvt.nl>
Date: Thu, 04 Aug 2005 10:26:45 +0200
Message-ID: <42F1D145.8060902@uvt.nl>


Holger Baer wrote:
.....
> Sorry, I'm out of my depths here, but what does
>
> select extract (data_char, '/document') from my_table
>
> return?

Exact what i would expect:

SQL> select extract (data_char, '/document') from my_table ;

EXTRACT(DATA_CHAR,'/DOCUMENT')



<document>
  <au first="Rüdiger" id="1">Rüdiger</au> </document>

<document>
  <au first="Ruediger" id="1">Rüdiger</au> </document>

> Regards,
> Holger

Greeting
Ko Received on Thu Aug 04 2005 - 03:26:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US