Introduction
In July 2017 Oracle announced to release updates for SQL Developer every quarter. Installing multiple versions of SQL Developer on the same machine is not a problem. Therefore many developers install a new version as soon as it becomes available. On the first start, SQL Developer offers to import the settings of the previous version. This works quite well for most settings. However, all third-party extensions must be installed manually afterwards. This is a cumbersome and boring task.
Hence, I decided to provide an Update Center containing freely available SQL Developer extensions to speed up the configuration of a new SQL Developer installation.
What’s an Update Center?
It’s just an XML file. It contains information about SQL Developer extensions. Essentially their names, versions, and download locations. I maintain this file in a dedicated GitHub repository. You can configure the Update Center in SQL Developer. This makes it easier to install many extensions. SQL Developer also checks for updates and notifies you when they are available.
What Extensions are Supported?
The Update Center contains the following SQL Developer extensions:
- utPLSQL – running utPLSQL tests, code coverage and more
- oddgen – invoking dictionary-driven code generators
- Bitemp Remodeler – generating non-temporal, uni-temporal and bi-temporal TAPI
- PL/SQL Cop – checking code for compliance with Trivadis PL/SQL & SQL guidelines
- PL/SQL Unwrapper – unwrapping PL/SQL code
- plscope-utils – integrating PL/Scope
- Show Me Password – showing the password in plain text for all connections
If you miss your favourite free extension, please open an issue on GitHub.
Configure Update Center
Click the Help menu and select Check for Updates…. Press the Add button to register the update center http://update.salvis.com/.
Then press Next > to show the available updates. Select the updates you want and press Next > to start the download process.
Wait until all updates are downloaded and press Finish. Finally, restart SQL Developer to install the downloaded updates.
Summary
A GitHub repository for a 90-line XML file seems ridiculous. However, I install SQL Developer in several environments. On my Mac, on machines of my customers and also in some VMs. This update site will certainly help me. I hope you find it useful too.
3 Comments
Hi
First of all thank you for your help. This tools are amazing!
I need to ask because I’m not been able to install PL/SQL Unrwrapper. The SQL Developer version which I’m using now is 20.4.1.407. Which will be the maximum version of SQL Developer in which I can install your software?
Thank you very much in advance
You’re welcome.
Unwrapper works in SQLDev 20.4.1. I use i there myself.
Please visit https://github.com/Trivadis/plsql-unwrapper-sqldev for more information. There is also an FAQ section. You can open an issue there and provide details what is not working, what you tried, etc. Screenshots are always helpful.
Thank you for you reply.
It was my mistake, when I use SQL Develper, for my own personal convenience I always create a folder SQL Developer inside C:\Program Files and then copy there sqldeveloper folder. This doesn’t allow the update and /or installations with a normal User,
To fix it I started sqldevloper as administrator and then Install the application using the updater without any issue.