Laur's blog
Sign in Subscribe

select

A collection of 2 posts
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
Select Rows Where Value from One Column Matches Other Column
db

Select Rows Where Value from One Column Matches Other Column

TL;DR: Use a JOIN. I've got a table representing a tree, using two columns: CREATE TABLE "EXAMPLE" ( "PROP_ID" VARCHAR2(20 BYTE) NOT NULL ENABLE, "PARENT_PROP_ID" VARCHAR2(20 BYTE) NOT NULL ENABLE, /* * Data ... */ "CLASS_ID" VARCHAR2(20
Nov 23, 2016 1 min read
Page 1 of 1
Laur's blog © 2025
  • Sign up
Powered by Ghost