view counter

PL/SQL Feed

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

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() {

Oracle Linux & VMWare Tools

Wow, I’ve been busy since OOW2011. This is the first post since I left for San Francisco. My Android phone got blown out by a forced upgrade and would only charge when actively connected across the USB to the computer. At the conference, my laptop was sidelined as a charger.

Hurray! Romney getting more Wall Street money than Obama

In the 2008 election campaign, Obama was the #1 recipient of contributions from Wall Street firms and individuals. Employees of Goldman Sachs, alone, contributed $1 million. I don't know about you, but when I heard of this, I was very worried. Is he really going to stand up to the very companies who paved his way to victory? Did he make a "back room" deal to let these robber barons and their underlings avoid prosecution and come out financially whole?

view counter