Someone on the Twitters was lamenting they had accidentally clobbered their code when they ‘copied over it’ in their clipboard. So basically you cut your code – it goes to clipboard, you copy something else, the :new replaces the :old. But. SQL Developer keeps an Extended Clipboard. It’s just what it sounds like. We keep a pretty decent Undo history …
Defaults for Exporting Data in Oracle SQL Developer
I was testing a reported bug in SQL Developer today – so the bug I was looking for wasn’t there (YES!) but I found a different one (NO!) – and I was getting frustrated by having to check the same boxes over and over again. What I wanted was INSERT STATEMENTS to the CLIPBOARD. I’m always doing the same thing, …
Copying Columns from Grid to Clipboard in SQL Developer
There are several ways to get data from a query or a table|view to the clipboard. You know the tried and true, copy and paste. But what if you only want one or more columns, not every column? There are several ways to do this, let’s see if we can’t identify all of them. Write your query to only include …