Jenkins Pipeline: Loop Multiple Databases
Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute
Read more
sql
Hierarchical Query: Roll-up leaf nodes to ancestors.
This query may be more applicable to a bill of materials type of query. I’ve added a new column to
Read moreRandom Data Generator
Today I came across this awesome website which will automatically generate data for you, and spit it out in different
Read moreExcel Style Row Numbering in SQL
Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.
Read moreFind ancestor from hierarchy
I needed to find a quick way to select a particular ancestor for a child in a hierarchical table. For
Read moreSnapper Now in SQL Developer
Snapper Now in SQL Developer
Read moreQuick Look: How to loop through an associative array indexed by varchar2.
Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2:
Read moreHow to quickly remove those pesky line numbers from copied code.
If you’re like me, you cut & paste tons of code. The trouble is however, that often line numbers are
Read more