If you would like to be an Oracle Certified Profressional on a developer level, OCA + Forms was always the only way to go. Until now! Oracle is currently running a beta exam on OCP that includes not Oracle Forms, but goes in deeper to PL/SQL. The official title: Oracle Advanced PL/SQL Developer Certified Professional. [...]

Popularity: 391 points

APEX is famous for it’s useful applications, so when the idea poped into my head that I would like to track my personal contracts, APEX was first in line to develop such an application.
The purpose of this app is to be able to track longrunning contracts with their renewalperiods. One month before you should end [...]

Popularity: 256 points

Logica does six presentations during the upcoming UKOUG on 1-5 December in Birmingham. For the record: The UKOUG is the largest European Oracle related conference with about 3,000 attendees.

When
What
Who

Monday, Dec 1, 11:00-12:00
Is my Disaster (re)covered?
Piet de Visser

Tuesday, Dec 2, 13:05-13:50
Streamlining the Sales Cycle - Integrating Salesforce.com CRM with Oracle Quoting
Paul Colton

Thursday, Dec 4, 10:45-11:30
Being Steven [...]

Popularity: 214 points

Logica Denmark is proud to announce an free full day APEX seminar in collaboration with Oracle. Come by and hear Anthony Rayner from Oracle UK introduce the product and talk about what is coming in release 4.0. Erik Birklund Andersen and Peter Lorenzen will talk about Logica’s experience with APEX and the business opportunities [...]

Popularity: 387 points

Ok, so there’s this very useful standard function called ‘ADD_MONTHS’ in Oracle, which gives you your date added with a couple of months.
Here’s a situation: two date (time) fields. I wanted to calculate the time difference between the two. And I mean the exact(!) time difference. Hours, minutes and seconds also. Now that’s not the [...]

Popularity: 342 points

Finally, I can offload some of my UKOUG stuff.
First the Budget-justification (management is reading - sometimes). Like every year, I can justify visiting UKOUG as a training cost. I have learned more in four days UKOUG then I would have on just about any (Oracle) course and have saved my employer some money [...]

Popularity: 217 points

An eyeopener for me when constructing sql queries in a complex environment was the use of analytic functions. As appose to aggregated functions, you can use more analytic functions on one table instead of constructing multiple inline views to accomplish “the same”.
For those of you who like to see examples:
select job_id
, sum(salary)
from employees
group by job_id;
has [...]

Popularity: 290 points

From the 11g New Features Guide:
“New in 11.1 is the ability to mark a PL/SQL function to indicate that its result should be cached to allow lookup, rather than recalculation, on the next access when the same parameter values are called. This function result cache saves significant space and time. Oracle does this transparently using [...]

Popularity: 263 points

Oracle 11g is shipped with a number of great new PL/SQL features. One of them - although a very small one - is that access to sequences is allowed in PL/SQL, so no need to “SELECT seq.nextval INTO n FROM dual” anymore!
DECLARE
  n NUMBER;
BEGIN
  SELECT seq.nextval
  INTO n
  FROM dual;
END;

can now be coded as
DECLARE
  n NUMBER;
BEGIN
  n := seq.nextval;
END;

For “currval” the [...]

Popularity: 330 points

In SQL Developer v1.2 the trigger tab for views is missing. You can add this tab (and many many others you can think of) by using User Defined Extensions.
Create an XML file with the definition of the tab:
<?xml version=”1.0″ encoding=”UTF-8″?>
<items>
  <item type=”editor” node=”ViewNode” vertical=”true”>
    <title><![CDATA[Triggers]]></title>
    <query>
      <sql>
        <![CDATA[select table_owner
                , trigger_name
                , trigger_type
                , triggering_event
                , status
                from user_triggers
                where table_name = :OBJECT_NAME
        ]]>
      </sql>
    </query>
    <subquery type=”code”>
      <query>
        <sql><![CDATA[ select dbms_metadata.get_dll
                                ('TRIGGER'
                                ,:trigger_name
                                ,:object_owner
                                ) SQL
                       from dual
                ]]>
        </sql>
      </query>
    </subquery>
  </item>
</items>
Save this file and add it as an User Defined Extension of type “Editor” (using Tools / Preferences [...]

Popularity: 283 points