Using the Oracle Developer Days VirtualBox Image
As many of you know @krisrice put together a great VM for the Oracle Developer Days and while the content is great for education, I find us using it more and...
Home
Recent Posts
Explain Plan, Autotrace and Diff
A SQL statement can be executed in many different ways, such as full table scans, index scans, nested loops, and hash joins. The query optimizer determines t...
UKOUG 2011
I’m speaking next week at the UK Oracle User Group at the ICC in Birmingham. The topic will be one I’ve posted several times about which is Tuning, Refactori...
login.sql, SQLPROMPT and worksheets
SQLDeveloper has had support for a login.sql for several releases now. You can set this in the preferences at
Substitution Variables in SQL*Plus
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
SQLPLus as an external tool in SQLDeveloper
@thatjeffsmith asked me today about running SQL*Plus from SQLDeveloper for his current sql file. This has been shown before, but there is a simple way to ad...
Proxy Connections
While looking at some issues with specific connection upgrades, I’ve been playing with proxy connections in SQL Developer, and while easy to do, can be inter...
SQL Developer 3.1 EA1 Available
SQL Developer 3.1 EA is now available for download here. Have a look and try out several of the new features introduced as part of this release. We have d...
Tuning, Refactoring and Instrumentation
For all those who attended the talk today, this is a promise partially fulfilled in that I had said I would post in more detail about the talk. At a high le...
SQL Developer Data Pump Support - Part 2
Welcome to part 2 of this feature on our introduction of data pump functionality into SQL Developer. Previously, we walked through exporting from the databa...