The Late Show with David Letterman used to have a bit called, ‘Stupid Pet Tricks.’ I quit watching because I prefer his Scottish and funnier future-replacement, Craig Ferguson. But I will take advantage of some Google-Fu to drive some traffic to ye olde blog (can you tell I’m in the UK this week?)
So most folks GET copy and paste in Windows and Mac. Ctrl or Apple + C for copy, and + V for paste.
In SQL Developer if I do this in a grid, I can get my data out onto the clipboard.
Most folks are OK with this, and here’s what it looks like:
Copying Data Out of a Grid WITHOUT Column Headers
Everyone gets this.
What folks need a little help figuring out is how to do the same operation BUT
WITH Column Headers
The magical mystery keystroke sequence is
Ctrl + Shift + C
This works on a single cell or row selection as well.[text] ENAME
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7566 JONES MANAGER 7839 02-APR-81 12.00.00 2975 20
For what it’s worth, my dog, Bart the pug, only does one trick. He goes crazy if you don’t give him a doggie-treat when leaving or entering the house. What an awesome dog.