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...
Home
Recent Posts
Setting up Eclipse with SVN on OSX Mavericks
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...
Convert SQLServer to Oracle using files - Part 4
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...
Convert SQLServer to Oracle using files - Part 3
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...
Convert SQL Server to Oracle using files - Part 2
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...
Convert SQL Server to Oracle using files - Part 1
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...
Configuring ODBC to MySQL from Oracle
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. ...
Configuring MySQL on EL5, Setting Passwords and Network Access
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...
Clickable SQL*Plus Errors
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
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...