With the recent release of SQL Developer 4.0.1 there has been some very minor bug fixes for Oracle Data Miner. But there has been one particular enhancement that I wanted to have a look at. This blog post will look at this new feature and how you can use it too. In the previously released version of the Oracle Data Miner tool we had a Graph Node. This is really a new feature (more...)
The PL/SQL Debugger works pretty much out of the box when used with a previous Oracle version. These are the things we needed in place before we could start debugging PL/SQL:
- A grant of the DEBUG CONNECT SESSION privilege.
- EXECUTE privilege on DBMS_DEBUG_JDWP.
- EXECUTE privilege on the stored procedure you want to debug.
- Make sure the stored procedure is “Compiled for Debug”.
Jeff Smith talks about it in this post.
But what happens when you (more...)
So far this December Oracle has released version upgrades for three of their products:
- Joel Kallman announced Oracle APEX 4.2.4 is now available. It appears to be mainly fixes & enhancements to Package Applications, so maybe it's time to give them all a go & see if they (more...)
If you have been using the last versions of the Oracle Data Miner tool that have been released as part of SQL Developer 4 EA1 and EA2, you may have noticed that the layout of your worksheets and other areas are inconsistent each time you open ODM.
This can be (more...)
This, the last part of a four part tutorial goes over the movement of data using files generated by Oracle SQL Developer.
Looking at the data move scripts that we generated in an earlier part. We need to zip up the files and copy them to the SQL Server machine (more...)
In part 1
we generated the offline capture scripts to take to the SQL Server machine, unloaded the metadata, zipped it up and copied it back to out local machine. In part 2
we used SQL Developer to create a migration project and load the capture files into SQL Developer. (more...)
Ok, Now we have the files as generated and moved in part 1
, we can now start SQL Developer to load the files. Start up SQL Developer and create a connection with the following privileges: CONNECT, RESOURCE and CREATE VIEW.
When the connection is opened, right click on it (more...)
Apparently, being able to use Oracle’s SQL Developer to connect to SQL Server databases has been around for a while (via third party drivers), but I only started using it today for the first time, with SQL Developer 4 EA2 after my colleague mentioned it to me this afternoon First (more...)
I find myself installing and running mysql of different versions in different places for different reasons all the time (well often enough to do it and not remember the little things that cost time when setting up) Its with that in mind, I'm making notes for myself and you (more...)
One of our more popular features is ‘DB Doc.’ It’s like JAVADOC for the database. Pick a connection, right-click, and go. It will generate an HTML documentation set for that schema.
For version 4, we’ve introduced a few enhancements based on user requests. That’s right, you asked, and we (more...)
You may have noticed a few posts lately where I’m talking about new and improved features in SQL Developer version 4.0. You may have also been too busy to read all of them. For shame! But that’s OK.
I’ll be doing a webcast with ODTUG on Tuesday, August 20 (more...)
Working on a table? Maybe you need to investigate the stats while you also browse some data.
But this is a BIG table. You know how to do the ‘split document trick,’ but that’s not quite cutting it. You need more screen real estate. Wouldn’t it be nice (more...)
One of the cooler features SQL Developer offers is the ‘split document.’ If you don’t know what I’m talking about, please take 90 seconds and read this short post first.
Ok, well that worked well for pretty much every type of editor in SQL Developer save one – the (more...)
This feature is going to be hard to cover in a single post, but I’m going to try anyway. The Reports interface received performance improvements, a few tweaks to make them easier to build, a slew of new charting options, and more visual control to tweak. Oh, it’s also available (more...)
“Explain Plans are useless.”
Yikes. Really? Don’t we spend all day looking at execution plans?
To clarify, I would say that explain plans could be useless.
If you do an Explain, you’re actually looking at a theoretical plan, not the ‘actual’ plan.
From the docs:
With the query (more...)
Ugly code, we all write it.
I don’t mean bad code either, just hard to read code. Developers who haven’t figured out how to use the TAB and ENTER keys – what’s up with that? — and why is Jeff talking to himself in his Seinfeld voice again?
So one (more...)
SQL Developer has had a command-line interface of sorts. The primary use cases were for formatting files and running unit tests. However, we wanted to expand the support to include things like generating Carts and running reports.
Instead of just creating a few more one-off interfaces, we kind of started (more...)