Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

pl/sql

Ajax APEX Cloud JavaScript Oracle Application Express (Apex) Oracle Developement PL/SQL 

APEX: Fetch CLOB data via AJAX callback.

April 6, 2020April 9, 2020 cruepprich ajax, apex, apex.ajax.clob, application express, callback, dynamic action, javascript, oracle, pl/sql

In my use case, I needed to fetch data (JSON) larger than 32k into a JavaScript variable. In APEX versions

Read more
Oracle Developement 

Setting And Retrieving CLOB values in APEX with JavaScript

September 1, 2015 cruepprich apex, collections, javascript, oracle, pl/sql

Here is a very helpful blog post by Andy Tulley on how to set/get CLOB values from an APEX collection.

Read more
Oracle Developement 

Where is my schema?

July 17, 2015 cruepprich apex, application express, oracle, pl/sql

I just came accross a little nuisance: During attempt to load some spreadsheet data into a new table using the

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

APEX 5: Convert Skillbuilder’s Modal to Universal Theme

June 1, 2015 cruepprich apex, application express, javascript, jquery, oracle, orclapex, pl/sql

If you have implemented the Skillbuilder’s Modal Page Plugin in an application of a previous version of APEX, and want

Read more
Oracle Developement 

Set Session State with JavaScript and dynamic action

January 16, 2015 cruepprich apex, application express, javascript, oralce, pl/sql, session state

I have two page items, P1_FIRST_NAME and P1_LAST_NAME whose values I wish to remain in session state. Here are two ways

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 

Enkitec APEX Resource Center

December 18, 2013 cruepprich apex, application express, oracle, pl/sql

I’m proud to announce the launch of the Enkitec APEX Resource Center (aka ARC) this week. It consists of a

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 

Geocoding with PL/JSON

September 17, 2013 cruepprich address elements, api, curly brackets, geocoding, google maps, json, pl/json, pl/sql

The Google Maps API geocoding web service makes it easy to geocode addresses. You can pass an address to the

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