THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

SQL*Developer Plug-In /*+ First Contribution */

With the help of an anonymous friend, I’ve made available a new SQL*Developer Plug-In. To setup your SQL*Developer 1.1+, proceed as below :

  • Select “Help | Check for Updates…” menu
  • On the “Source” screen, click on the “Add…” button and fill the form as below
    • name : ArKZoYd Update Center
    • location : http://arkzoyd.free.fr/center.xml
  • On the “Updates” screen, select “Partitioning tab and dimension objects 0.2” and proceed
  • Click on “End” Button and restart SQL*Developer

Note :
For some obscure reasons, I’m working on, you may need to restart SQL*Developer a second time. I’m working on it and may provide a fix once I found how the solve this issue.

Plug In screen shot

Graphic 1 – Select “Display Image” to show the Plug-In

The Plug-In adds 2 features to SQL*Developer :

  • A dimension folder below the Materialized view folder
  • A new tab named “Additional Partitioning” to the “Table” Editor

I wish I can continue to develop the Plug-In. Feel free to comment this post with your ideas, sample code and feedbacks

-Grégory
http://arkzoyd.blogspot.com

2 Responses

  1. Andrey Goryunov says:

    Hello Gregory,

    is there any chance to change existing templates especially for EXPLAIN PLAN
    to add more functionality like possibility to show additional information in
    screen tips – structure of indexes, indexes for tables etc.

    Regards,
    Andrey Goryunov

  2. dipak lohiya says:

    Hi ,
    i like to develop plugin for sql developer but uptill now i never develop any plugin.can you please give some guidline,how to develop plugin and some initial steps.

Leave a Reply

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @FN_Press2: Schooner Information Technology Teams with Pythian to Deliver Advanced Support and High... http://finanznachrichten.de/20
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more