Questions tagged [extract-value]
50 questions
3
votes
1 answer
Oracle: how to create a fast refresh materialized view that extracts data from XMLType?
I have a table xml_documents with two columns: a document_id column (primary key) and an xml column with some XML data, which is a schema-less XMLType. I can create a materialized view with just the document_id with:
create materialized view mv…
avernet
- 30,895
- 44
- 126
- 163
3
votes
2 answers
select distinct values on XMLType
I've got a table that has a XMLType field. The table is created and loaded using the following DDL/DML:
CREATE TABLE T_ECO_test_LOG
(
SECID NUMBER NOT NULL,
LOG_ATTRIBUTES SYS.XMLTYPE
)
INSERT INTO…
Jose L Martinez-Avial
- 2,191
- 4
- 28
- 42
2
votes
2 answers
How to select a particular Node name and its values in XML using Oracle SQL query?
I have a table called SOAP_MONITORING in which i have RESPONSE_XML column which is CLOB datatype. In this column large xml string is stored. I want to get the node name and node value from this xml string. Here is my xml :
user1930857
2
votes
1 answer
Extract/extractValue for tags with a namespace
I am trying to extract the value of a tag with a name space in Oracle 10g. My query is
select extract(xmltype(xml_text),
'/feed/entry[1]/yt:statistics',
'xmlns:yt="http://gdata.youtube.com/schemas/2007"') title
from …
v4venletta
- 43
- 1
- 1
- 6
2
votes
1 answer
Extract value from XML
I am using this query to extract the value from the XML
SELECT extractvalue(column_value, '/TransactionLimitDTO/idTxn') "TxnId"
FROM TABLE(XMLSequence(XMLType(mg.limits)
…
Java_Alert
- 1,159
- 6
- 24
- 50
1
vote
1 answer
xpath of Self-closing XML tag using mysql ExtractValue
Is there any way to know whether the self-closing(
Abin
- 540
- 4
- 15
1
vote
2 answers
How to write a HQL select query using extractvalue function in select clause of query in Java?
I'm writing code with hibernate wherein I have to use the MySQL extractvalue function, in the SELECT clause of the query. However, I am getting the error:
java.lang.IllegalArgumentException: org.hibernate.QueryException: No data type for node:…
jaihind
- 1,090
- 1
- 8
- 9
1
vote
2 answers
How to retrieve specific data from XML in Oracle table
I have an oracle table which has a column that stores XML. The XML has the following syntax:
BUSINESSPROCESSID
RETAIL
…
Edgars Ceplis
- 11
- 2
1
vote
1 answer
ExtractValue function of mysql not working
select extractvalue( SELECT CONCAT("'",(SELECT LCASE('
user3612181
- 603
- 1
- 5
- 8
1
vote
0 answers
MySQL Extract multiple values from a XML column and put them into separated columns
With the following code
SELECT EXTRACTVALUE('xyz', '//b') as 'values'
I got this:
values
x y z
But I want this:
value_b0 value_b1 value_b2
x y z
How?
Frank Souza
- 111
- 2
1
vote
2 answers
MySQL/MariaDB namespaces xml returns null with ExtractValue
I have some xml data on a MariaDB database and need to do some parsing.
I ve tried using the following code to extraxt some values but no matter what i may try i keep getting null as output
SELECT xmlResponse FROM myDataBase.xmlLogging where id =…
nikolas
- 723
- 2
- 17
- 37
1
vote
1 answer
Oracle clob read value of a field paramater
I have an xml like below. There are many nodes b4 and after this but they are irrelevant.
sometag
1
RaoLinMau
- 11
- 2
1
vote
2 answers
0
votes
1 answer
extract the value between a tag and add title attribute using jquery
I have several a tags as shown below on a dynamically generated page
Inventory
I need to traverse through…
Neel
- 613
- 4
- 14
- 32
0
votes
3 answers
Retrieve data from XML CLOB Column in Oracle SQL
I try to retrieve XML Information from a CLOB Column and didn't manage to find suitable examples for the pattern understanding using EXTRACTVALUE() or as it seems to be outdated XMLQUERY() / XMLTABLE(). You may have better example sources than the…
Hisager
- 27
- 6