21 February 2008

SQL Developer EA2 is out now

Oracle SQL Developer1.5 Early Adopter's Release 2 (EA2) is out now. We made it available last night and already the forum is buzzing with EA2 feedback and the developers are focusing on the next phase.
Did you know you can build a gauge into a report or a data grid query in SQL Developer 1.5? Take a look at this quick demo. Below is a preview screen shot.

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.