view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

Upgrade to APEX 4.1: Invalid Login Credentials

Always a good idea to upgrade on a Friday.. not... In the past I did numerous upgrades to the latest APEX release, and never really encountered big problems. It was always very smooth, kudos to the APEX-team. If something went wrong it was mostly my own fault, which I will admit now. Because of the history of going very smoothly, I dare to do an upgrade on Friday morning.And it did go smoothly, the upgrade to APEX 4.1 ...

Explorations into Pipelined Functions (9398)

The 2 November quiz on pipelined table functions and autonomous transactions prompted the following submission from Chad Lee of Telligen, specifically the 2nd and 3rd points in the explanation:

(1) A pipelined table function returns a row to its invoker (a query) with the PIPE ROW statement and then continues to process rows.

Solution Your profile could not be opened correctly in Chrome

Hi,
When you try to open your chrome web explorer, if you get “Your profile could not be opened correctly” error, try to following solution:
There are several solutions on the web for this, but this is the easiest way:

-Close Chrome
-Go to “C:\Users\[user]\AppData\Local\Google\Chrome\User Data”
-Delete “Web Data” and “Web Data-journal” files. (If you cannot delete it, restart computer)
-Open Chrome

"Average" function not correct due to lack of rounding? (9397)

The 1 November quiz tested your knowledge of the ability to select from a nested table using the TABLE operator and, in this case, apply the AVG function to the contents of the collection. The question asked in the quiz was:

Which of the choices implements a function named plch_avg that calculates the average of all elements in a collection of the above type so that the following block displays "3.5" after execution

Oh, Frabjous Joy, I Am a Grandfather!

Our very first ever in the whole wide world grandchild - our granddaughter, Loey Lucille - was born at 9:54 this morning, 30 October 2011. Ah, what a glorious feeling! Everyone is doing well, excellently, and Loey Lucille is clearly thriving from the get-go. Her father, my son, Chris, has posted the first three photos of what is sure to be a deluge of multimedia recording of Loey's life at his Facebook page.

Wanted: Your Ideas for Key PL/SQL Enhancements

On November 9, I will be doing the keynote presentation at the 100th member meeting of the Northern California OUG. The day before that I will visit with the PL/SQL development team at Oracle HQ.

Wanted: Your Ideas for Enhancements to PL/SQL

On November 9, I will be doing the keynote presentation at the 100th member meeting of the Northern California OUG. The day before that I will visit with the PL/SQL development team at Oracle HQ.

Correlated subqueries and Query Transformations

Many times ask me my students when we have – at least – two solutions for a particular problem, which is the best queries ?
The correct answer is typically complex, and started “ It depends on ….” or “let’s see the environment…”.
Let’s see the following simple example:
We would like to select those employees whose salaries are greater than their department’s average salary!
1. First solution can be:

Using jQuery to determine the checked items

In one of my APEX pages, I needed to know in javascript which checkboxes are checked. The checked values are placed in an item as a semi-colon (;) delimited list. To be able to do this I created a Dynamic Action which was quite easy.. what wasn't that easy (at least for me, and that's why I want to keep it here so the next time I need this) was to write the javascript expression to get the values.jQuery is simply amazing. Using a "simple" expression it is "easy" to get exactly what was needed.


$('input:checkbox:checked').map(function() {
view counter