Skip to main content

Posts

Showing posts from June, 2007

Adding a missing tab to SQL Developer

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
                                …