Posts by Tag

SQL Developer

SQLDev: How unshared worksheets should work!

less than 1 minute read

Unshared worksheets are created to have a private connection to the database.  When that unshared worksheet is closed, the connection and session for it shou...

Clickable SQL*Plus Errors

1 minute read

Running lots of scripts in SQL*Plus is nice when they are working correctly. But what about when they fail?  Its a pain to figure out what went wrong, unless...

Clickable SQL*Plus Scripts

less than 1 minute read

When you have a load of SQL*Plus scripts, they can be a pain to manage and just simply get around. In the next version of SQL Developer, you’ll be able to ho...

Application Migration - Part 3

3 minute read

Ok, Finally, we have got to part 3 of Application Migration.  In Part 1, we outlined a program which runs in Sybase through iSQL.  We then followed this, in ...

Using History Keys in SQL*Plus

3 minute read

I was working through a bug the other day and using SQL*Plus, which for the most part doesn’t annoy me too much.  However, one of the things that does, is ha...

UKOUG 2011

less than 1 minute read

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...

Substitution Variables in SQL*Plus

2 minute read

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

1 minute read

@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...

SQL Developer 3.1 EA1 Available

less than 1 minute read

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

less than 1 minute read

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

2 minute read

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...

SQL Developer Data Pump Support - Part 1

3 minute read

In 3.1 we’re adding support for Data Pump, which has replaced exp and imp.  In SQL Developer, we’ve added this in the DBA navigator which has support for sev...

SQL*Plus Formatting Commands

4 minute read

Since the last post on SQL*Plus commands was completed, we have also added more functionality to the SQL Developer’s SQL*Plus support.     Specifically, we’v...

Detecting Hangs in Java

1 minute read

One of the things we are looking into right now is performance in SQL Developer and concurrency of operations. Sometimes, operations that are spawned on the ...

Cross Connection Queries

1 minute read

When we were hooking up the “Copy to Oracle” functionality, Dermot added a cool bit of code to allow us to do queries across connections.

Migration Features in SQL Developer 3.0

2 minute read

Since we released 2.1, we’ve worked with several customers and have added several great new features which have helped these customers increase the automatio...

Back on the Chain Gang

less than 1 minute read

After a great holiday season, its time to get back to the grindstone. We released SQL Developer 1.5.3 before Christmas which is our first translated release....

Back to Top ↑

oracle

Making Git cmd line fancy - ish :)

1 minute read

So, we’re having a great time with git, fighting over how branches should work and what policy is best in our environment, which I suppose I’ll talk about in...

Run your SQL script from java NOW

1 minute read

Run them with the code we use for Oracle SQL Developer, SQLcl and REST Data Services. We’ve just released some of the code that underpins these tools in an a...

Docker Oracle and local installs

5 minute read

So you want Docker and to install and Oracle Database locally.  So did I and while I have VirtualBox and the Oracle Developer Day VM, I wanted to setup docke...

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

SQLcl - Code editing on the console

1 minute read

We’ve been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier.  The vide...

Connections Types in SQLcl

2 minute read

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same ...

SQLCl - LDAP anyone?

1 minute read

since  we released our first preview of SDSQL, we’ve made  a lot of changes to it and enhanced a lot of things too in there so it would be more useable.  One...

Clickable SQL*Plus Errors

1 minute read

Running lots of scripts in SQL*Plus is nice when they are working correctly. But what about when they fail?  Its a pain to figure out what went wrong, unless...

Clickable SQL*Plus Scripts

less than 1 minute read

When you have a load of SQL*Plus scripts, they can be a pain to manage and just simply get around. In the next version of SQL Developer, you’ll be able to ho...

Remote Debugging with SQL Developer revisited.

2 minute read

As part of the development process, we all have to work out the bugs in our code.  For all of us who use SQLDeveloper , we know how to debug with SQL Develop...

Proxy Connections

1 minute read

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 Data Pump Support - Part 2

2 minute read

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...

SQL Developer Data Pump Support - Part 1

3 minute read

In 3.1 we’re adding support for Data Pump, which has replaced exp and imp.  In SQL Developer, we’ve added this in the DBA navigator which has support for sev...

SQL*Plus Commands

1 minute read

Its funny how many people forget we support a lot of the basic SQLPlus functionality in SQL Developer. For example, today, Paulo blogged on how to stop scann...

Back to Top ↑

SQLDEVELOPER

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

Wheres my TNS connection? SHOW TNS

1 minute read

Lots of users have been head scratching as to which tnsnames.ora is being found and used when  connecting to the database with SQLDeveloper and with SQLcl. ...

SQLcl - Code editing on the console

1 minute read

We’ve been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier.  The vide...

Connections Types in SQLcl

2 minute read

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same ...

SQLCl - LDAP anyone?

1 minute read

since  we released our first preview of SDSQL, we’ve made  a lot of changes to it and enhanced a lot of things too in there so it would be more useable.  One...

SDSQL - Editing Anyone?

less than 1 minute read

Since we dropped our beta out of SQLDeveloper 4.1 and announced SDSQL, we’ve been busy getting some of the new things out to users.  We support SQL*plus edit...

SQL Tuning Advisor - 101

3 minute read

The DBMS_SQLTUNE package is the interface for tuning SQL on demand. Its Doc pages are here.  Have a look.  There is a lot of stuff to do to set a tuning task...

Using Hierarchical Profiler in SQL Developer

3 minute read

One of the features exposed since SQL Developer 1.5 is the hierarchical profiler.  There have been several blogs and things about this but none I think that ...

Remote Debugging with SQL Developer revisited.

2 minute read

As part of the development process, we all have to work out the bugs in our code.  For all of us who use SQLDeveloper , we know how to debug with SQL Develop...

Explain Plan, Autotrace and Diff

2 minute read

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...

login.sql, SQLPROMPT and worksheets

1 minute read

SQLDeveloper has had support for a login.sql for several releases now.  You can set this in the preferences at

Proxy Connections

1 minute read

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...

Back to Top ↑

sqlcl

Oracle REST JDBC Driver and SQLcl

less than 1 minute read

Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release. Dermot posted this morning ab...

SQLcl Embedded JREs

less than 1 minute read

When you are restrained in the JRE that you can use with SQLcl, you can embed your own in the sqlcl directory tree.  We currently support 1.8 meaning that if...

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

Wheres my TNS connection? SHOW TNS

1 minute read

Lots of users have been head scratching as to which tnsnames.ora is being found and used when  connecting to the database with SQLDeveloper and with SQLcl. ...

SQLcl - Code editing on the console

1 minute read

We’ve been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier.  The vide...

Connections Types in SQLcl

2 minute read

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same ...

Code Insight on SQLcl

less than 1 minute read

Here’s a little preview of the code insight we have in SQLcl.  These changes are part of EA2 which are coming out very soon.  This also shows the buffer and ...

SQLCl - LDAP anyone?

1 minute read

since  we released our first preview of SDSQL, we’ve made  a lot of changes to it and enhanced a lot of things too in there so it would be more useable.  One...

Back to Top ↑

sqlplus

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

SQLcl - Code editing on the console

1 minute read

We’ve been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier.  The vide...

Connections Types in SQLcl

2 minute read

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same ...

Code Insight on SQLcl

less than 1 minute read

Here’s a little preview of the code insight we have in SQLcl.  These changes are part of EA2 which are coming out very soon.  This also shows the buffer and ...

SQLCl - LDAP anyone?

1 minute read

since  we released our first preview of SDSQL, we’ve made  a lot of changes to it and enhanced a lot of things too in there so it would be more useable.  One...

SDSQL - Editing Anyone?

less than 1 minute read

Since we dropped our beta out of SQLDeveloper 4.1 and announced SDSQL, we’ve been busy getting some of the new things out to users.  We support SQL*plus edit...

Remote Debugging with SQL Developer revisited.

2 minute read

As part of the development process, we all have to work out the bugs in our code.  For all of us who use SQLDeveloper , we know how to debug with SQL Develop...

SQLPLus as an external tool in SQLDeveloper

1 minute read

@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

1 minute read

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...

Back to Top ↑

SQL*Plus

Clickable SQL*Plus Errors

1 minute read

Running lots of scripts in SQL*Plus is nice when they are working correctly. But what about when they fail?  Its a pain to figure out what went wrong, unless...

Clickable SQL*Plus Scripts

less than 1 minute read

When you have a load of SQL*Plus scripts, they can be a pain to manage and just simply get around. In the next version of SQL Developer, you’ll be able to ho...

Application Migration - Part 3

3 minute read

Ok, Finally, we have got to part 3 of Application Migration.  In Part 1, we outlined a program which runs in Sybase through iSQL.  We then followed this, in ...

Using History Keys in SQL*Plus

3 minute read

I was working through a bug the other day and using SQL*Plus, which for the most part doesn’t annoy me too much.  However, one of the things that does, is ha...

login.sql, SQLPROMPT and worksheets

1 minute read

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

2 minute read

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

1 minute read

@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...

SQL*Plus Formatting Commands

4 minute read

Since the last post on SQL*Plus commands was completed, we have also added more functionality to the SQL Developer’s SQL*Plus support.     Specifically, we’v...

SQL*Plus Commands

1 minute read

Its funny how many people forget we support a lot of the basic SQLPlus functionality in SQL Developer. For example, today, Paulo blogged on how to stop scann...

Back to Top ↑

Migration Workbench SQL Developer

Substitution Variables in SQL*Plus

2 minute read

Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...

Scanning Applications

1 minute read

When re-platforming any application, there are specific things that must be changed in order to make that application work on the new platform. Database mig...

SQL Developer 3.0

less than 1 minute read

Last night we released SQL Developer 3.0. This has been a large release with a lot of new base features and new extensions. At a high level, these are the fe...

Disconnecting Folder Connections

less than 1 minute read

A post came in on the forum the other day about disconnecting numbers of connections in SQL Developer that are open. This was on the Feature request applicat...

Migration Estimation from SQL Developer

1 minute read

Last post we mentioned all the features of 3.0 for migration. This one, we’re taking it a bit further and looking at the overview of the migration project it...

Forum posts and questions

less than 1 minute read

One of the things I do quite a lot of is monitor the forums (fora?) for both SQL Developer and the Migration Workbench. Some of the features we’re putting to...

Back to Top ↑

worksheet

SQLDev: How unshared worksheets should work!

less than 1 minute read

Unshared worksheets are created to have a private connection to the database.  When that unshared worksheet is closed, the connection and session for it shou...

Clickable SQL*Plus Errors

1 minute read

Running lots of scripts in SQL*Plus is nice when they are working correctly. But what about when they fail?  Its a pain to figure out what went wrong, unless...

SQL Tuning Advisor - 101

3 minute read

The DBMS_SQLTUNE package is the interface for tuning SQL on demand. Its Doc pages are here.  Have a look.  There is a lot of stuff to do to set a tuning task...

Proxy Connections

1 minute read

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*Plus Formatting Commands

4 minute read

Since the last post on SQL*Plus commands was completed, we have also added more functionality to the SQL Developer’s SQL*Plus support.     Specifically, we’v...

Clicking around the worksheet

1 minute read

As we have been getting close to another EA release, one thing which struck me as pretty cool and something we haven’t talked about in a while are the click ...

Back to Top ↑

virtualbox

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

Using History Keys in SQL*Plus

3 minute read

I was working through a bug the other day and using SQL*Plus, which for the most part doesn’t annoy me too much.  However, one of the things that does, is ha...

Continuous Integration for SQL Tasks

2 minute read

One of my favourite integration tools is hudson.   Today, we’re going to show you how to setup hudson on the Oracle Developer Day image.  Since the image is ...

Back to Top ↑

Oracle Developer Day VM

Connections Types in SQLcl

2 minute read

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same ...

Code Insight on SQLcl

less than 1 minute read

Here’s a little preview of the code insight we have in SQLcl.  These changes are part of EA2 which are coming out very soon.  This also shows the buffer and ...

Configuring ODBC to MySQL from Oracle

3 minute read

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC. ...

Using History Keys in SQL*Plus

3 minute read

I was working through a bug the other day and using SQL*Plus, which for the most part doesn’t annoy me too much.  However, one of the things that does, is ha...

Back to Top ↑

Migration

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...

Migration Features in SQL Developer 3.0

2 minute read

Since we released 2.1, we’ve worked with several customers and have added several great new features which have helped these customers increase the automatio...

Multi Tasking - Men can’t do it.

1 minute read

But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.

Back to Top ↑

command line

SQLcl - Code editing on the console

1 minute read

We’ve been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier.  The vide...

SDSQL - Editing Anyone?

less than 1 minute read

Since we dropped our beta out of SQLDeveloper 4.1 and announced SDSQL, we’ve been busy getting some of the new things out to users.  We support SQL*plus edit...

Application Migration - Part 3

3 minute read

Ok, Finally, we have got to part 3 of Application Migration.  In Part 1, we outlined a program which runs in Sybase through iSQL.  We then followed this, in ...

Using History Keys in SQL*Plus

3 minute read

I was working through a bug the other day and using SQL*Plus, which for the most part doesn’t annoy me too much.  However, one of the things that does, is ha...

Back to Top ↑

Connections

Wheres my TNS connection? SHOW TNS

1 minute read

Lots of users have been head scratching as to which tnsnames.ora is being found and used when  connecting to the database with SQLDeveloper and with SQLcl. ...

Connections Types in SQLcl

2 minute read

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same ...

Proxy Connections

1 minute read

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...

Disconnecting Folder Connections

less than 1 minute read

A post came in on the forum the other day about disconnecting numbers of connections in SQL Developer that are open. This was on the Feature request applicat...

Back to Top ↑

linux

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

Configuring ODBC to MySQL from Oracle

3 minute read

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC. ...

Continuous Integration for SQL Tasks

2 minute read

One of my favourite integration tools is hudson.   Today, we’re going to show you how to setup hudson on the Oracle Developer Day image.  Since the image is ...

Back to Top ↑

SQLDEVELOPER ORACLE

Clicking around the worksheet

1 minute read

As we have been getting close to another EA release, one thing which struck me as pretty cool and something we haven’t talked about in a while are the click ...

Multi Tasking - Men can’t do it.

1 minute read

But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.

Now We’re Blogging

less than 1 minute read

Here we are now. Bloggin. I’ve been able to stay buried in code for long enough and now I have to publish. Well, I am the development manager for SQL Develop...

Back to Top ↑

database migration

Code Insight on SQLcl

less than 1 minute read

Here’s a little preview of the code insight we have in SQLcl.  These changes are part of EA2 which are coming out very soon.  This also shows the buffer and ...

Migration Estimation from SQL Developer

1 minute read

Last post we mentioned all the features of 3.0 for migration. This one, we’re taking it a bit further and looking at the overview of the migration project it...

Back to Top ↑

Oracle XE

SQL Developer Data Pump Support - Part 1

3 minute read

In 3.1 we’re adding support for Data Pump, which has replaced exp and imp.  In SQL Developer, we’ve added this in the DBA navigator which has support for sev...

SQL*Plus Formatting Commands

4 minute read

Since the last post on SQL*Plus commands was completed, we have also added more functionality to the SQL Developer’s SQL*Plus support.     Specifically, we’v...

Back to Top ↑

Tuning

Explain Plan, Autotrace and Diff

2 minute read

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

less than 1 minute read

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...

Tuning, Refactoring and Instrumentation

less than 1 minute read

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...

Back to Top ↑

scripts

Substitution Variables in SQL*Plus

2 minute read

Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...

Back to Top ↑

SQL Server

Back to Top ↑

open source

Making Git cmd line fancy - ish :)

1 minute read

So, we’re having a great time with git, fighting over how branches should work and what policy is best in our environment, which I suppose I’ll talk about in...

Run your SQL script from java NOW

1 minute read

Run them with the code we use for Oracle SQL Developer, SQLcl and REST Data Services. We’ve just released some of the code that underpins these tools in an a...

Back to Top ↑

maven

Run your SQL script from java NOW

1 minute read

Run them with the code we use for Oracle SQL Developer, SQLcl and REST Data Services. We’ve just released some of the code that underpins these tools in an a...

Back to Top ↑

Database Tools

Long Running Tasks in SQLcl

1 minute read

SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.

Run your SQL script from java NOW

1 minute read

Run them with the code we use for Oracle SQL Developer, SQLcl and REST Data Services. We’ve just released some of the code that underpins these tools in an a...

Back to Top ↑

git

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...

Making Git cmd line fancy - ish :)

1 minute read

So, we’re having a great time with git, fighting over how branches should work and what policy is best in our environment, which I suppose I’ll talk about in...

Back to Top ↑

Oracle Develop

Continuous Integration for SQL Tasks

2 minute read

One of my favourite integration tools is hudson.   Today, we’re going to show you how to setup hudson on the Oracle Developer Day image.  Since the image is ...

Back on the Chain Gang

less than 1 minute read

After a great holiday season, its time to get back to the grindstone. We released SQL Developer 1.5.3 before Christmas which is our first translated release....

Back to Top ↑

3.0

SQL Developer 3.0

less than 1 minute read

Last night we released SQL Developer 3.0. This has been a large release with a lot of new base features and new extensions. At a high level, these are the fe...

Migration Features in SQL Developer 3.0

2 minute read

Since we released 2.1, we’ve worked with several customers and have added several great new features which have helped these customers increase the automatio...

Back to Top ↑

Java

Run your SQL script from java NOW

1 minute read

Run them with the code we use for Oracle SQL Developer, SQLcl and REST Data Services. We’ve just released some of the code that underpins these tools in an a...

Detecting Hangs in Java

1 minute read

One of the things we are looking into right now is performance in SQL Developer and concurrency of operations. Sometimes, operations that are spawned on the ...

Back to Top ↑

define

Substitution Variables in SQL*Plus

2 minute read

Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...

SQL*Plus Commands

1 minute read

Its funny how many people forget we support a lot of the basic SQLPlus functionality in SQL Developer. For example, today, Paulo blogged on how to stop scann...

Back to Top ↑

substitution variables

Substitution Variables in SQL*Plus

2 minute read

Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...

SQL*Plus Commands

1 minute read

Its funny how many people forget we support a lot of the basic SQLPlus functionality in SQL Developer. For example, today, Paulo blogged on how to stop scann...

Back to Top ↑

11g

SQL Developer Data Pump Support - Part 2

2 minute read

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...

SQL Developer Data Pump Support - Part 1

3 minute read

In 3.1 we’re adding support for Data Pump, which has replaced exp and imp.  In SQL Developer, we’ve added this in the DBA navigator which has support for sev...

Back to Top ↑

Data pump

SQL Developer Data Pump Support - Part 2

2 minute read

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...

SQL Developer Data Pump Support - Part 1

3 minute read

In 3.1 we’re adding support for Data Pump, which has replaced exp and imp.  In SQL Developer, we’ve added this in the DBA navigator which has support for sev...

Back to Top ↑

Instrumentation

UKOUG 2011

less than 1 minute read

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...

Tuning, Refactoring and Instrumentation

less than 1 minute read

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...

Back to Top ↑

refactoring

UKOUG 2011

less than 1 minute read

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...

Tuning, Refactoring and Instrumentation

less than 1 minute read

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...

Back to Top ↑

glogin

Connections Types in SQLcl

2 minute read

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same ...

login.sql, SQLPROMPT and worksheets

1 minute read

SQLDeveloper has had support for a login.sql for several releases now.  You can set this in the preferences at

Back to Top ↑

configuration

Back to Top ↑

macosx

Docker Oracle and local installs

5 minute read

So you want Docker and to install and Oracle Database locally.  So did I and while I have VirtualBox and the Oracle Developer Day VM, I wanted to setup docke...

Back to Top ↑

MySQL

Configuring ODBC to MySQL from Oracle

3 minute read

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC. ...

Back to Top ↑

offline

Back to Top ↑

Eclipse

Setting up Eclipse with SVN on OSX Mavericks

4 minute read

So My macbook pro died the other day and much to my wife’s amusement, my dell laptop died 30 minutes later with disk errors as I hadn’t used in it in forever...

Back to Top ↑

MACOS

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

Setting up Eclipse with SVN on OSX Mavericks

4 minute read

So My macbook pro died the other day and much to my wife’s amusement, my dell laptop died 30 minutes later with disk errors as I hadn’t used in it in forever...

Back to Top ↑

svn

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...

Setting up Eclipse with SVN on OSX Mavericks

4 minute read

So My macbook pro died the other day and much to my wife’s amusement, my dell laptop died 30 minutes later with disk errors as I hadn’t used in it in forever...

Back to Top ↑

dbtools

Docker Oracle and local installs

5 minute read

So you want Docker and to install and Oracle Database locally.  So did I and while I have VirtualBox and the Oracle Developer Day VM, I wanted to setup docke...

Back to Top ↑

TABLE EDIT ORACLE SQLDEVLOPER

Editing data in big tables

less than 1 minute read

I saw this floating around the forums over the last few days and it’s one of those things that are more of an annoyance than anything else. Consider having ...

Back to Top ↑

dbms_output sqldeveloper oracle

DBMS_OUTPUT from multiple worksheets

less than 1 minute read

While I’m talking today, heres another feature people have been asking for. Separated DBMS_OUTPUT from the main worksheet. This way you can now have severa...

Back to Top ↑

Threads

Multi Tasking - Men can’t do it.

1 minute read

But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.

Back to Top ↑

Openworld

Multi Tasking - Men can’t do it.

1 minute read

But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.

Back to Top ↑

1.5.3

Back on the Chain Gang

less than 1 minute read

After a great holiday season, its time to get back to the grindstone. We released SQL Developer 1.5.3 before Christmas which is our first translated release....

Back to Top ↑

1.5.4

Back on the Chain Gang

less than 1 minute read

After a great holiday season, its time to get back to the grindstone. We released SQL Developer 1.5.3 before Christmas which is our first translated release....

Back to Top ↑

simplicity sql developer

Kissing - Keeping it simple

less than 1 minute read

I spotted this today and couldnt resist talking about it. I was reading Eric Burke’s comic look at typical product masters and looking inwardly at our own p...

Back to Top ↑

Bridge

Cross Connection Queries

1 minute read

When we were hooking up the “Copy to Oracle” functionality, Dermot added a cool bit of code to allow us to do queries across connections.

Back to Top ↑

stack

Detecting Hangs in Java

1 minute read

One of the things we are looking into right now is performance in SQL Developer and concurrency of operations. Sometimes, operations that are spawned on the ...

Back to Top ↑

new

SQL Developer 3.0

less than 1 minute read

Last night we released SQL Developer 3.0. This has been a large release with a lot of new base features and new extensions. At a high level, these are the fe...

Back to Top ↑

SQL_Developer SQL*Plus

SQL*Plus Commands

1 minute read

Its funny how many people forget we support a lot of the basic SQLPlus functionality in SQL Developer. For example, today, Paulo blogged on how to stop scann...

Back to Top ↑

scan

SQL*Plus Commands

1 minute read

Its funny how many people forget we support a lot of the basic SQLPlus functionality in SQL Developer. For example, today, Paulo blogged on how to stop scann...

Back to Top ↑

reports

SQL*Plus Formatting Commands

4 minute read

Since the last post on SQL*Plus commands was completed, we have also added more functionality to the SQL Developer’s SQL*Plus support.     Specifically, we’v...

Back to Top ↑

formatting

SQL*Plus Formatting Commands

4 minute read

Since the last post on SQL*Plus commands was completed, we have also added more functionality to the SQL Developer’s SQL*Plus support.     Specifically, we’v...

Back to Top ↑

DBA

SQL Developer Data Pump Support - Part 1

3 minute read

In 3.1 we’re adding support for Data Pump, which has replaced exp and imp.  In SQL Developer, we’ve added this in the DBA navigator which has support for sev...

Back to Top ↑

export

SQL Developer Data Pump Support - Part 1

3 minute read

In 3.1 we’re adding support for Data Pump, which has replaced exp and imp.  In SQL Developer, we’ve added this in the DBA navigator which has support for sev...

Back to Top ↑

import

SQL Developer Data Pump Support - Part 2

2 minute read

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...

Back to Top ↑

EA

SQL Developer 3.1 EA1 Available

less than 1 minute read

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...

Back to Top ↑

3.1

SQL Developer 3.1 EA1 Available

less than 1 minute read

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...

Back to Top ↑

proxy_user

Proxy Connections

1 minute read

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...

Back to Top ↑

external tools

SQLPLus as an external tool in SQLDeveloper

1 minute read

@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...

Back to Top ↑

SQL

Substitution Variables in SQL*Plus

2 minute read

Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...

Back to Top ↑

sqlpath

login.sql, SQLPROMPT and worksheets

1 minute read

SQLDeveloper has had support for a login.sql for several releases now.  You can set this in the preferences at

Back to Top ↑

UKOUG

UKOUG 2011

less than 1 minute read

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...

Back to Top ↑

autotrace

Explain Plan, Autotrace and Diff

2 minute read

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...

Back to Top ↑

explain plan

Explain Plan, Autotrace and Diff

2 minute read

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...

Back to Top ↑

laptop

Back to Top ↑

network adapters

Back to Top ↑

image

Continuous Integration for SQL Tasks

2 minute read

One of my favourite integration tools is hudson.   Today, we’re going to show you how to setup hudson on the Oracle Developer Day image.  Since the image is ...

Back to Top ↑

continuous integration

Continuous Integration for SQL Tasks

2 minute read

One of my favourite integration tools is hudson.   Today, we’re going to show you how to setup hudson on the Oracle Developer Day image.  Since the image is ...

Back to Top ↑

Hudson

Continuous Integration for SQL Tasks

2 minute read

One of my favourite integration tools is hudson.   Today, we’re going to show you how to setup hudson on the Oracle Developer Day image.  Since the image is ...

Back to Top ↑

SCM

Back to Top ↑

remote debug

Remote Debugging with SQL Developer revisited.

2 minute read

As part of the development process, we all have to work out the bugs in our code.  For all of us who use SQLDeveloper , we know how to debug with SQL Develop...

Back to Top ↑

dbms_output

Remote Debugging with SQL Developer revisited.

2 minute read

As part of the development process, we all have to work out the bugs in our code.  For all of us who use SQLDeveloper , we know how to debug with SQL Develop...

Back to Top ↑

hierarchial profiler

Using Hierarchical Profiler in SQL Developer

3 minute read

One of the features exposed since SQL Developer 1.5 is the hierarchical profiler.  There have been several blogs and things about this but none I think that ...

Back to Top ↑

sql tuning advisor

SQL Tuning Advisor - 101

3 minute read

The DBMS_SQLTUNE package is the interface for tuning SQL on demand. Its Doc pages are here.  Have a look.  There is a lot of stuff to do to set a tuning task...

Back to Top ↑

utilities

Using History Keys in SQL*Plus

3 minute read

I was working through a bug the other day and using SQL*Plus, which for the most part doesn’t annoy me too much.  However, one of the things that does, is ha...

Back to Top ↑

application Migration

Application Migration - Part 3

3 minute read

Ok, Finally, we have got to part 3 of Application Migration.  In Part 1, we outlined a program which runs in Sybase through iSQL.  We then followed this, in ...

Back to Top ↑

Usability

Clickable SQL*Plus Scripts

less than 1 minute read

When you have a load of SQL*Plus scripts, they can be a pain to manage and just simply get around. In the next version of SQL Developer, you’ll be able to ho...

Back to Top ↑

passwords

Back to Top ↑

network

Back to Top ↑

yum

Configuring ODBC to MySQL from Oracle

3 minute read

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC. ...

Back to Top ↑

ODBC

Configuring ODBC to MySQL from Oracle

3 minute read

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC. ...

Back to Top ↑

Hetrogenous Services

Configuring ODBC to MySQL from Oracle

3 minute read

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC. ...

Back to Top ↑

unixodbc

Configuring ODBC to MySQL from Oracle

3 minute read

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC. ...

Back to Top ↑

Convert

Back to Top ↑

Translate

Back to Top ↑

Offline Capture

Back to Top ↑

SQLServer

Back to Top ↑

DDL generation

Back to Top ↑

data move

Back to Top ↑

Mavericks

Setting up Eclipse with SVN on OSX Mavericks

4 minute read

So My macbook pro died the other day and much to my wife’s amusement, my dell laptop died 30 minutes later with disk errors as I hadn’t used in it in forever...

Back to Top ↑

javaHL

Setting up Eclipse with SVN on OSX Mavericks

4 minute read

So My macbook pro died the other day and much to my wife’s amusement, my dell laptop died 30 minutes later with disk errors as I hadn’t used in it in forever...

Back to Top ↑

SVNKit

Setting up Eclipse with SVN on OSX Mavericks

4 minute read

So My macbook pro died the other day and much to my wife’s amusement, my dell laptop died 30 minutes later with disk errors as I hadn’t used in it in forever...

Back to Top ↑

subclipse

Setting up Eclipse with SVN on OSX Mavericks

4 minute read

So My macbook pro died the other day and much to my wife’s amusement, my dell laptop died 30 minutes later with disk errors as I hadn’t used in it in forever...

Back to Top ↑

unshared

SQLDev: How unshared worksheets should work!

less than 1 minute read

Unshared worksheets are created to have a private connection to the database.  When that unshared worksheet is closed, the connection and session for it shou...

Back to Top ↑

sdsql

SDSQL - Editing Anyone?

less than 1 minute read

Since we dropped our beta out of SQLDeveloper 4.1 and announced SDSQL, we’ve been busy getting some of the new things out to users.  We support SQL*plus edit...

Back to Top ↑

editor

SQLcl - Code editing on the console

1 minute read

We’ve been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier.  The vide...

Back to Top ↑

cool

SQLcl - Code editing on the console

1 minute read

We’ve been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier.  The vide...

Back to Top ↑

cloud

Back to Top ↑

tunnel

Back to Top ↑

tnsnames

Wheres my TNS connection? SHOW TNS

1 minute read

Lots of users have been head scratching as to which tnsnames.ora is being found and used when  connecting to the database with SQLDeveloper and with SQLcl. ...

Back to Top ↑

tns

Wheres my TNS connection? SHOW TNS

1 minute read

Lots of users have been head scratching as to which tnsnames.ora is being found and used when  connecting to the database with SQLDeveloper and with SQLcl. ...

Back to Top ↑

TNS_ADMIN

Wheres my TNS connection? SHOW TNS

1 minute read

Lots of users have been head scratching as to which tnsnames.ora is being found and used when  connecting to the database with SQLDeveloper and with SQLcl. ...

Back to Top ↑

headless

Developer Days VM Startup and Shutdown, SQLcl

3 minute read

If you’re developing on a remote platform, chances are that you are using a Virtual Machine. (VM)  In Oracle, we release a virtual machine called the  ”Oracl...

Back to Top ↑

jre

SQLcl Embedded JREs

less than 1 minute read

When you are restrained in the JRE that you can use with SQLcl, you can embed your own in the sqlcl directory tree.  We currently support 1.8 meaning that if...

Back to Top ↑

embedded

SQLcl Embedded JREs

less than 1 minute read

When you are restrained in the JRE that you can use with SQLcl, you can embed your own in the sqlcl directory tree.  We currently support 1.8 meaning that if...

Back to Top ↑

REST

Oracle REST JDBC Driver and SQLcl

less than 1 minute read

Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release. Dermot posted this morning ab...

Back to Top ↑

jdbc

Oracle REST JDBC Driver and SQLcl

less than 1 minute read

Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release. Dermot posted this morning ab...

Back to Top ↑

ORDS

Oracle REST JDBC Driver and SQLcl

less than 1 minute read

Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release. Dermot posted this morning ab...

Back to Top ↑

Docker

Docker Oracle and local installs

5 minute read

So you want Docker and to install and Oracle Database locally.  So did I and while I have VirtualBox and the Oracle Developer Day VM, I wanted to setup docke...

Back to Top ↑

GitHub

Back to Top ↑

dbtools-common

Run your SQL script from java NOW

1 minute read

Run them with the code we use for Oracle SQL Developer, SQLcl and REST Data Services. We’ve just released some of the code that underpins these tools in an a...

Back to Top ↑

flatten

Back to Top ↑

module

Back to Top ↑

version

Back to Top ↑

revision

Back to Top ↑

bash

Making Git cmd line fancy - ish :)

1 minute read

So, we’re having a great time with git, fighting over how branches should work and what policy is best in our environment, which I suppose I’ll talk about in...

Back to Top ↑

git desktop

Back to Top ↑

tortoisegit

Back to Top ↑

windows

Back to Top ↑

unix

Back to Top ↑

osx.

Back to Top ↑

bfg

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...

Back to Top ↑

subversion

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...

Back to Top ↑

lfs

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...

Back to Top ↑

gitlab

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...

Back to Top ↑

SQLcl

Long Running Tasks in SQLcl

1 minute read

SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.

Back to Top ↑

Oracle

Long Running Tasks in SQLcl

1 minute read

SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.

Back to Top ↑

Liquibase

Long Running Tasks in SQLcl

1 minute read

SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.

Back to Top ↑