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

Facebook Twitter Email

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 @OracleODA: Welcome to #Oracle #OracleODA
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



Social links powered by Ecreative Internet Marketing