1

Topic: Sampling in request from CLOB fields

There is a table table_test, in it there is a field pole_test format CLOB. In it are stored xml the big data on volume. As I do not understand as java works with storage, I would like select' to select only that is really necessary from this field. That is in the field there is a record:
----------------------------
(A heap of all)
<n:inn> 00000000000 </n:inn>
(A heap of all)
----------------------------
Question.
Tell, please, what request to select only "00000000000"?

2

Re: Sampling in request from CLOB fields

azsx;
See XML DB Developer's Guide

3

Re: Sampling in request from CLOB fields

Search .

4

Re: Sampling in request from CLOB fields

But after all the plug-in for analysis xml is not required to me, I should select two parameters from record. Made so
SELECT substr (pole_test, (instr (pole_test, ' <n:inn> ') + 7), (pole_test, (instr (pole_test, ' <n:inn> ') + 7) - instr (pole_test, ' </n:inn> ')) FROM table_test
Why so it is not correct?

5

Re: Sampling in request from CLOB fields

Excuse
substr (pole_test, (instr (pole_test, ' <n:inn> ') + 7), (instr (pole_test, ' </n:inn> ') - instr (pole_test, ' <n:inn> ') - 7)) FROM table_test

6

Re: Sampling in request from CLOB fields

test case with the given initial data considerably expedites matters.
With probability of 95 % by its preparation you understand a problem.

7

Re: Sampling in request from CLOB fields

azsx;
And still it is possible FBO to construct an index if it is necessary also quickly all it to do

8

Re: Sampling in request from CLOB fields

[quote =-2] it is passed...
select ' 00000000000 ' from table_test where pole_test like ' % <n:inn> 00000000000 </n:inn> % ';

How many days he on CLOB' so will search for it? smile