06 February 2008

New Year, New Features, New Release and a Few Tips!

I should be blogging! So much to tell you and so little time! I thought when I was first tagged for the "8Things", that I'd use that to start blogging again, and then the second time I was tagged I was sure I would, but even the third time didn't help... Aah well, maybe one day I'll tell you a few things about me that you don't know. I want to tell you I'm going back to India in March (did you know I went last year?) and never got around to that either. All in good time.

The SQL Developer news is that Oracle SQL Developer 1.5 Early Adopters 1 (EA1) is out. If anything that should have had me straight on the blog, but I am tracking feature issues and feedback on the forum and so didn't. Then one of the team sent me this tip and it was just too good to lose:

You can use alt-shift-# (where # is a number) to create a "editor bookmark", then use alt-# to navigate to it.

So, if you have a number of worksheets open, you can create a bookmark selecting alt-shift-1, which assigns an alt-1 navigator shortcut to the active editor. You'll see a small numbered icon on editor's tab. If you repeat that for each open tab, then you can then navigate between tabs using keyboard strokes, alt-1, alt-2, etc.

A Few Other Keyboard Strokes:
  • To use code editor templates you have created (in the preferences) use the keyboard shortcut ctrl+shift+T.
  • The keyboard shortcut for the SQL History is crtl +up or ctrl + down. This replaces whatever is in the worksheet with lines from your history.
  • To create a new, unshared worksheet, use the keystroke ctrl+shift+N. This creates a separate, unshared worksheet. The unshared worksheets are labeled as follows: HR_ _<1>
Did you know that if you open a xxx.trc file in Oracle SQL Developer you'll see a sortable, formatted view of the file?

So it seems there are lots of tips about, which you might like to know about or which you have discovered on your own and wished someone had told you. I'm going to try to tell you more and often as I can. If you have some for me, I'd love to hear about them.



Chandu said...

Is there a way I can export the results displayed in the results grid when a query is run to an excel file(similar to the one in TOAD)?

Sue said...

Yes! Right click on the grid and select your required export format.

You are better off asking questions on the Forum: http://forums.oracle.com/forums/forum.jspa?forumID=260
than here. On the forum, many folk answer and you can set up preferences to have the forum send the response to you directly in your mail.


Damage Inc. said...

I'm Ignacio from Argentina, as you can see, my inglish is horrible, but is (with help of GoogleTranslator!) Enough to congratulate you and the SQL Developer Team for the development of the most functional SQL tool for LINUX.

Sue said...

That is good to hear. Thank you for taking the time to send us some positive feedback.