Tag Archives: SQL Developer

SQL Developer 4.0

Oracle have given birth to SQL Developer 4.0 today, as announced by Jeff Smith. I had access to the first Early Adopter a few weeks before it hit the OTN download page, so it feels like I’ve been using some flavour of SQL Developer 4 for ages. I’m kinda old-school, so I still find myself working […]

Performance Reports in SQL Developer 4 EA2

SQL Developer 4 EA2 includes a performance node in the DBA tree.   You can use this to view ADDM, AWR and ASH reports directly from SQL Developer. I know I can get these from Cloud Control, but previously I tended to pull these out from the command line on the server. This is a […]

SQL Developer 4 EA2 Connecting to SQL Server

I wrote a blog post some time ago about using SQL Developer 3.x to connect to SQL Server. I tried the same thing today from SQL Developer 4 EA2 and it works just fine. You have to download the 3rd party JDBC driver and point SQL Developer to it. You can read how to do it […]

SQL Developer 3.1 : Scheduler Support…

I had a play around with the scheduler support in SQL Developer 3.1 today. I’m late to the party because most of it has been there since 3.0, but what the hell. SQL Developer 3.1 Scheduler (DBMS_SCHEDULER) Support It’s more of an opinion piece, so it started as a blog post, but it got too […]

SQL Developer 3.1 : Data Pump Wizards…

One of the things that sounded kinda neat in SQL Developer 3.1 was the Data Pump Wizards, so I thought I would have a play with them. SQL Developer 3.1 Data Pump Wizards (expdp, impdp) As you would expect, they are pretty straight forward. They can’t do everything you can do with expdp and impdp, […]

SQL Developer and MS SQL Server…

This afternoon I’ve been cleaning up some data in an SQL Server database. I decided to use SQL*Developer to connect to SQL Server by following this post. Using Oracle SQLDeveloper to access SQLServer (The “Check for Updates” functionality doesn’t seem to work properly on my SQL*Developer running on CentOS 5 (64-bit), so I had to install […]