Skip to content

Content Tagged "query"

Page 1 of 1

Call an Oracle Function from Spring

June 29, 2017Categories: Software, Tutorial
The easiest way to call a function from Spring is using SELECT . For example, having a function HAS_PANEL_FLAG_OK with two parameters and returning an integer , the function call looks like: This will return all flags for the panels matching the condition. Java Call The query string can be…

Add XML to PostgreSQL from Python

July 24, 2015Category: Software
One of the projects I worked on was to import a large number of XML files in a PostgreSQL database (as XML files). I chose python to do it. Here are the steps: Database The data source is the SCOPUS database which has a silly number of entries (approx 20,000,000), most containing 2 XML files…

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