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

Home -> Community -> Usenet -> c.d.o.misc -> Re: XML in data, how do display just one tag?

Re: XML in data, how do display just one tag?

From: Michael Moore <hicamel_at_yahoo.com>
Date: 7 Nov 2001 16:41:54 -0800
Message-ID: <ca4074a8.0111071641.76008314@posting.google.com> 





> 

> One might do this:

> 

> select transaction_id,parameter_str from sometable where parameter_str

> like '<cm_technology>TERAYON PROPRIETARY</cm_technology>'

> 



How about :


select transaction_id, '<cm_technology>TERAYON PROPRIETARY</cm_technology>'
from sometable where parameter_str 


like '<cm_technology>TERAYON PROPRIETARY</cm_technology>'
Received on Wed Nov 07 2001 - 18:41:54 CST












Original text of this message













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