Name

XMLType.getStringVal — The function returns the string-value of the current node like XPATH function 'string()'.

Synopsis

XMLType.getStringVal ( );

Description

The function returns the string-value of the current node. This is similar to the XPATH function 'string()'.

Return Types

The member function returns wide string.

Examples

Example24.554.A table with an XMLType column

This populates a table with XML data and then selects the string-value of an 'ename' element from the appropriate record.

create table TEST_XMLS  (I integer primary key, XMLVAL XMLType);
insert into TEST_XMLS  values (1, XMLType('<emp><empno>221</empno><ename>John</ename></emp>'));
insert into TEST_XMLS  values (2, XMLType('<po><pono>331</pono><poname>PO_1</poname></po>'));
insert into TEST_XMLS  values (3, XMLType('<oil-rig
xml:id="14a_06" water="0.413"/><oil-rig
xml:id="14b_06" water="0.402"/>'));
select e.XMLVAL.extract ('//ename').getStringVal() as ENAME
  from TEST_XMLS  as e
  where e.XMLVAL.existsNode('/emp/empno')
ENAME
NVARCHAR
_______________________________________________________________________________

John

1 Rows. -- 00000 msec.