SQLDev: How unshared worksheets should work!
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...
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...
This, the last part of a four part tutorial goes over the movement of data using files generated by Oracle SQL Developer. In part 1 we generated the offline...
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 mac...
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...
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 r...
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...
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...
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 ...
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...
For those of you who end up using the Oracle Developers Day VM for more that just demo’s but playing with other things too, will find that at some point, you...
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...
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
@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 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...
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...
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...
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...
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...
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 ...
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.
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...
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....
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 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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
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...
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...
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...
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 ...
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...
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 r...
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...
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...
For those of you who end up using the Oracle Developers Day VM for more that just demo’s but playing with other things too, will find that at some point, you...
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...
We’ve done a number of posts on using the Oracle Developer Day VM’s and this is an addition to it, showing how we can set up a subversion repository using ap...
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...
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...
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...
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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
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...
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. ...
We’re always trying to make SQLcl easier to connect to your database, whether its at your place or in the cloud. So, one other thing we have added to enable...
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...
Turloch posted this today, which is like aliases for SQL*Net connection URL’s which are used to connections like this:
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 ...
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...
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...
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...
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 ...
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...
We’ve done a number of posts on using the Oracle Developer Day VM’s and this is an addition to it, showing how we can set up a subversion repository using ap...
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...
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...
SQLDeveloper has had support for a login.sql for several releases now. You can set this in the preferences at
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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
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...
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...
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...
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. ...
We’re always trying to make SQLcl easier to connect to your database, whether its at your place or in the cloud. So, one other thing we have added to enable...
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...
Turloch posted this today, which is like aliases for SQL*Net connection URL’s which are used to connections like this:
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 ...
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 ...
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...
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...
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...
Turloch posted this today, which is like aliases for SQL*Net connection URL’s which are used to connections like this:
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 ...
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 ...
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...
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...
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...
@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...
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...
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...
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...
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 ...
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...
SQLDeveloper has had support for a login.sql for several releases now. You can set this in the preferences at
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
@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...
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...
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...
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
For those of you who end up using the Oracle Developers Day VM for more that just demo’s but playing with other things too, will find that at some point, you...
We’ve done a number of posts on using the Oracle Developer Day VM’s and this is an addition to it, showing how we can set up a subversion repository using ap...
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 ...
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...
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 ...
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 ...
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. ...
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...
For those of you who end up using the Oracle Developers Day VM for more that just demo’s but playing with other things too, will find that at some point, you...
We’ve done a number of posts on using the Oracle Developer Day VM’s and this is an addition to it, showing how we can set up a subversion repository using ap...
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...
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 mac...
Many people want to migrate their SQL Server databases and do not have direct network access to the database. In Oracle SQL Developer, we can migrate from SQ...
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...
But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.
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...
Turloch posted this today, which is like aliases for SQL*Net connection URL’s which are used to connections like this:
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...
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 ...
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...
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. ...
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 ...
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...
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...
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...
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. ...
For those of you who end up using the Oracle Developers Day VM for more that just demo’s but playing with other things too, will find that at some point, you...
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 ...
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 ...
But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.
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...
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 ...
Many people want to migrate their SQL Server databases and do not have direct network access to the database. In Oracle SQL Developer, we can migrate from SQ...
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...
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...
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...
Straight from Kris’ Blog
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...
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...
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...
This, the last part of a four part tutorial goes over the movement of data using files generated by Oracle SQL Developer. In part 1 we generated the offline...
Many people want to migrate their SQL Server databases and do not have direct network access to the database. In Oracle SQL Developer, we can migrate from SQ...
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
This, the last part of a four part tutorial goes over the movement of data using files generated by Oracle SQL Developer. In part 1 we generated the offline...
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 mac...
Many people want to migrate their SQL Server databases and do not have direct network access to the database. In Oracle SQL Developer, we can migrate from SQ...
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 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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
We had the situation lately where we have a bunch of modules in a project and a common parent. Now when we go to update the project version we need to updat...
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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.
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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
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...
Getting Git installed in lots of places for a team can be a irksome. Part of your team is running windows, maybe with Cygwin, others with various flavours o...
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...
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 ...
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....
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...
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...
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...
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 ...
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
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...
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
SQLDeveloper has had support for a login.sql for several releases now. You can set this in the preferences at
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 r...
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...
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...
We’ve done a number of posts on using the Oracle Developer Day VM’s and this is an addition to it, showing how we can set up a subversion repository using ap...
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. ...
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 r...
This, the last part of a four part tutorial goes over the movement of data using files generated by Oracle SQL Developer. In part 1 we generated the offline...
Many people want to migrate their SQL Server databases and do not have direct network access to the database. In Oracle SQL Developer, we can migrate from SQ...
Getting Git installed in lots of places for a team can be a irksome. Part of your team is running windows, maybe with Cygwin, others with various flavours o...
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...
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...
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...
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...
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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
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...
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 ...
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...
But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.
But SQL Developer can. We’ve spent some time reworking the worksheet for 2.0 to allow several things to happen.
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....
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....
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...
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.
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 ...
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...
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...
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...
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...
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...
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...
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...
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 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...
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...
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...
@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...
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had ...
SQLDeveloper has had support for a login.sql for several releases now. You can set this in the preferences at
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...
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...
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...
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...
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...
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 ...
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 ...
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 ...
We’ve done a number of posts on using the Oracle Developer Day VM’s and this is an addition to it, showing how we can set up a subversion repository using ap...
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...
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...
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 ...
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...
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...
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 ...
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...
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 r...
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 r...
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. ...
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. ...
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. ...
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. ...
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...
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...
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...
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...
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 mac...
This, the last part of a four part tutorial goes over the movement of data using files generated by Oracle SQL Developer. In part 1 we generated the offline...
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...
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...
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...
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...
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...
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...
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...
We’re always trying to make SQLcl easier to connect to your database, whether its at your place or in the cloud. So, one other thing we have added to enable...
We’re always trying to make SQLcl easier to connect to your database, whether its at your place or in the cloud. So, one other thing we have added to enable...
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. ...
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. ...
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. ...
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...
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...
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...
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...
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...
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...
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...
Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change. Why? Well, we haven’t cha...
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...
We had the situation lately where we have a bunch of modules in a project and a common parent. Now when we go to update the project version we need to updat...
We had the situation lately where we have a bunch of modules in a project and a common parent. Now when we go to update the project version we need to updat...
We had the situation lately where we have a bunch of modules in a project and a common parent. Now when we go to update the project version we need to updat...
We had the situation lately where we have a bunch of modules in a project and a common parent. Now when we go to update the project version we need to updat...
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...
Getting Git installed in lots of places for a team can be a irksome. Part of your team is running windows, maybe with Cygwin, others with various flavours o...
Getting Git installed in lots of places for a team can be a irksome. Part of your team is running windows, maybe with Cygwin, others with various flavours o...
Getting Git installed in lots of places for a team can be a irksome. Part of your team is running windows, maybe with Cygwin, others with various flavours o...
Getting Git installed in lots of places for a team can be a irksome. Part of your team is running windows, maybe with Cygwin, others with various flavours o...
Getting Git installed in lots of places for a team can be a irksome. Part of your team is running windows, maybe with Cygwin, others with various flavours o...
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...
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...
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...
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...
SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.
SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.
SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.