Archive for June, 2007

Adding a missing tab to SQL Developer

Monday, June 25th, 2007 by Roel

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: 551 points

ODTUG Conference 2007 day 2

Friday, June 22nd, 2007 by Jacob Boje

First of all I wish to congratulate my colleague Peter Lorenzen with his first presentation at ODTUG. He did a great job! He has posted his presentation on the blog also.
In the first session of the day, Jan Carlin from Oracle Corporation held a very interesting presentation about integrating Oracle Forms with a service oriented [...]

Popularity: 312 points

How to Make Your Oracle APEX Application Secure

Thursday, June 21st, 2007 by Peter Lorenzen

I have just made my first presentation at the ODTUG Conference. Actually it was my first public presentation ever It went really well. I have uploaded my PowerPoint presentation and the accompanying article if you want to know more about APEX and security.
Popularity: 656 points

Popularity: 656 points

ODTUG Conference 2007 day 1

Wednesday, June 20th, 2007 by Peter Lorenzen

There were a lot of good presentations on the first day of the conference. Matt Topper talked about how-to secure Web Services. Mostly it was about Oracle Web Service Manager (OWSM) which Oracle has acquired from Oblix. We learned the differences between Gateways and Agents. The OWSM repository can be file based or put in [...]

Popularity: 373 points

ODTUG Conference day 0: Oracle Fusion Symposium

Tuesday, June 19th, 2007 by Jacob Boje

The ODTUG kaleidoscope starts tomorrow but today we got underway with the Oracle Fusion Symposium. Paul Dorsey and co. had as usually planned a full day. Paul gave a short introduction to the theme of the day; Oracle Fusion Middleware and proceeded with ADF and an interesting tale about thick databases vs. thin databases. Thick [...]

Popularity: 407 points

Oracle database 11g releasedate : July 11, 2007!

Tuesday, June 19th, 2007 by Roel

It is official now : official release announcement can be found here.
Popularity: 462 points

Popularity: 462 points

Oracle Application Express: What’s it All About?

Tuesday, June 5th, 2007 by Peter Lorenzen

The second quarter 2007 edition of the Oracle Development Tools User Group (ODTUG) Technical Journal contains this article about APEX: Oracle Application Express:What’ s it All About?
Check it out
Popularity: 371 points

Popularity: 371 points

Soaked with Information

Monday, June 4th, 2007 by Piet de Visser

The Miracle DataBase Forum (Scotland): It was Intense.
After some much needed time out (to do work, go home to do different work, and come back to do more work) I can finally enter my notes and experiences from the Miracle Database Forum - Scotland. And I prefer to call it MDBF-S, not MS-DBF, as that [...]

Popularity: 793 points