Archive for November, 2014

PL/SQL RPN calculator – version 2

November 24, 2014 7 comments

This post presents a new version of my PL/SQL RPN calculator.
It now includes :

  • a regex-free tokenizer
  • a recursive-descent parser to validate the input expression
  • an improved evaluator based on a compiled “type-aware” RPN expression

Program and additional objects available here :

Update 2016-08-07 : RPN_UTIL_v2 is now deprecated.
Please download and use PLCalc instead.


Read more…

Categories: Fun, PL/SQL Tags: ,

XMLTransform Tips and Tricks

November 16, 2014 4 comments

No real new stuff there but as I’m a big user of XSLT transformation inside the database, I just thought I could share a few interesting (hidden) things I’ve encountered so far, that is :

  1. Using XSLT parameters with XMLTransform
  2. Using text output method with XMLTransform and XMLType.transform method


Read more…

How To : Parse sibling repeating groups without wrapper element

November 9, 2014 1 comment

Long time no post, so here’s a new (short) article.
Behind the cryptic title lies a situation like this :


where each logical record {id, name} is not enclosed by a row tag.
This is the result we want out of that data :

----- ---------
    1 SMITH
    2 WILSON
    3 GRANT


Read more…