Laur's blog
Sign in Subscribe

query

A collection of 4 posts
influxdb
influxdb

Grep in Flux Language for InfluxDB 2+

Queries built with the query builder are inflexible. See here gow to make them more adaptive.
Dec 18, 2022 3 min read
Call an Oracle Function from Spring
function

Call an Oracle Function from Spring

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: SELECT panel_id, HAS_PANEL_FLAG_OK('17584', panel_id) AS flag FROM panels WHERE
Jun 29, 2017 1 min read
Add XML to PostgreSQL from Python
load

Add XML to PostgreSQL from Python

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,
Jul 24, 2015 4 min read
Memory dump: Work with XMLField in Oracle (part 2)
oracle

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

TL;DR: Here I present a SQL example from creating the table to performing a SELECT. Table of Contents 1. Part 1 - Prerequisites 2. Part 2 - Create a table and perform a SELECT 3. Part 3 - User Python to insert data 4. Part 4 - references Table
Mar 5, 2014 2 min read
Page 1 of 1
Laur's blog © 2025
  • Sign up
Powered by Ghost