Category Archive for "PL/SQL"

Execute PL/SQL code and return content to page (Plugin)

Here is a Dynamic Action plugin for Oracle Application Express (Apex) that lets you execute PL/SQL code in the database, and then send output generated on the server (via calls to the “HTP.P” procedure) back to any element on the

Read More
Execute PL/SQL in background

PL/SQL Logik in APEX zu platzieren ist etwas völlig Normales und findet nahezu überall täglich statt. Gelegentlich kommt es aber vor, dass aus APEX heraus solche PL/SQL-Logik angestoßen werden soll, die länger laufen wird. Hinterlegt man diese ganz normal als

Read More
Determine the difference between two dates

Function created Now, i just create a view to demonstrate with: SQL> create or replace view temp_view   2  as   3  select to_date(’01-JAN-1999 12:02:04′, ‘dd-mon-yyyy hh24:mi:ss’ ) d1,   4         to_date(’15-MAR-1999 01:34:23′, ‘dd-mon-yyyy hh24:mi:ss’ ) d2   5  from

Read More

Logger 2.0.0 Alpha

Logger is a PL/SQL logging and debugging framework. It's used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0. I contacted

Read More
PL/SQL Email Client package: version 1.0 is available

PL/SQL Email Client package: version 1.0 is available Nach einer sehr langen Zeit (um genau zu sein: nach 2 1/2 Jahren), konnte ich endlich eine neue Version meines Projektes PL/SQL Email Client online stellen. Neu in Version 1.0 sind

Read More

Reset sequence values to align with table

Migrating data between environments sometimes requires the need to update the sequence next value. Here’s a pice of code that might help when you need to alter certain sequence values.

Read More

Select into statements..

One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table into local variables. The problem is that the data may or may not exist (i.e. return 0..1 rows). They're several

Read More

NTH Value windowing

In my previous post which highlighted some analytic functions, I mentioned that the windowing clause must be explicitly defined when using the NTH_VALUE function. To recap, here's the example I used for NTH_VALUE which lists the 2nd highest salary for

Read More

Interesting Analytical Functions

I had to write some reports for a personal application of mine last night and needed to expand beyond my usual set of analytic functions that I normally use. I thought it would be a good idea to do a

Read More

Using a comma-separated list in an SQL query

Dit artikel gaat over het gebruik van de IN Operator,..

Read More