Skip to content

Content Tagged "xpath"

Page 1 of 1

Use XPath in PL/PGSQL for Batch Processing

March 5, 2016Categories: Software, Tutorial
A while ago I had to process XML loaded in a PostgreSQL database. The task was to extract references from a publication structure. Fortunately, PostgreSQL allows you to use XPath in plpgsql , but there are some things you need to be aware. First, you need to note all namespaces: Then, you can use…

Memory dump: Work with XMLField in Oracle (part 2)

March 5, 2014Category: Software
TL;DR: Here I present a SQL example from creating the table to performing a SELECT . Table of Contents Part 1 - Prerequisites Part 2 - Create a table and perform a SELECT Part 3 - User Python to insert data Part 4 - references Table and XMLTYPE Once we've seen that we have XMLTYPE available…

All tags