Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

apex

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 

APEX 5 Login Screen

July 23, 2015 cruepprich apex, application express, javascript, oracle, pls/sql

The login screens of some of the APEX 5 sample applications have a nice look and include a check mark

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 

Quick & Dirty: Instal htop on Redhead Enterprise Linux 7 (RHEL7)

April 23, 2015 cruepprich apex, application express, enterprise, linux, linux 7, oracle, redhat, rhel, rhel7

I typically prefer htop to the regular top command. Here are the steps I took to install htop on the

Read more
Oracle Developement 

Quick & Dirty: Create a pluggable database in Oracle 12c

April 22, 2015 cruepprich 12c, apex, application express, database, oracle, pluggable

Log in as sys Change to CDB$ROOT and verify container: SQL> alter session set container = cdb$root; Session altered. SQL> show

Read more
Oracle Developement 

Chase that cat! Enable scp on the Oracle Developer Day VM

April 16, 2015 cruepprich apex, appliance, bashrc, developer day, linux 7, oracle, oracle 12c, virtual box, vm

I just installed the Oracle Developer Day – Database VirtualBox Appliance and noticed I wasn’t able to scp from my

Read more
Oracle Developement 

Spatial Data Example for Apex

March 30, 2015 cruepprich apex, latitude and longitude, spatial metadata

Staring with version 4.2.5, APEX provides the APEX_SPATIAL package that allows you to manage spatial metadata and indexes. Below is a

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
  • ← Previous
Oracle ACE
Copyright © 2023 Christoph's 2 Cents. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.