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 [...]
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, [...]
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 [...]