Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

sql

Cloud DevOps Groovy Jenkins Oracle Cloud Infrastructrure Oracle Developement Oracle Tools PL/SQL 

Jenkins Pipeline: Loop Multiple Databases

June 30, 2020June 30, 2020 cruepprich devops, groovy, jenkins, oracle, pipeline, plssql, sql

Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute

Read more
Oracle Developement 

Random Data Generator

April 9, 2014 cruepprich data, oracle, pl/sql, sql, xml

Today I came across this awesome website which will automatically generate data for you, and spit it out in different

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools 

Excel Style Row Numbering in SQL

February 3, 2014 cruepprich apex, application express, connect by, hierarchy, level, oracle, pl/sql, plsql, row numbering, sql

Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.

Read more
Oracle Developement PL/SQL 

Find ancestor from hierarchy

October 2, 2013March 4, 2022 cruepprich apex, connect by, grand parent, hierarchical, hierarchy, oracle, parent, pl/sql, plsql, query, reports, sql, traverse

I needed to find a quick way to select a particular ancestor for a child in a hierarchical table. For

Read more
Oracle Developement 

Snapper Now in SQL Developer

May 26, 2013 cruepprich developer, oracle, snapper, sql

Snapper Now in SQL Developer

Read more
Oracle Application Express (Apex) Oracle Developement PL/SQL 

Quick Look: How to loop through an associative array indexed by varchar2.

April 16, 2012November 16, 2022 cruepprich apex, application express, array index, arrays, associative array, collections, loop, oracle, pl/sql, pls/sql, plsql, programming, sql, table

Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2:

Read more
Oracle Developement 

How to quickly remove those pesky line numbers from copied code.

December 15, 2011 cruepprich gvim, sql, sql*plus, vi, vim

If you’re like me, you cut & paste tons of code. The trouble is however, that often line numbers are

Read more
Oracle ACE
Copyright © 2023 Christoph's 2 Cents. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.