Opening Unshared Worksheets via the Keyboard

thatjeffsmith SQL Developer 0 Comments

Tell Others About This Story:

Customer Question: How can I open an unshared worksheet using just the keyboard?

Ctrl+Shift+N on an existing worksheet is the easy answer.

Customer Followup Question: But, if you’re currently ON an existing unshared worksheet, this won’t work.

Then, you need to hit ALT+F10.

Jeff, What is an Unshared Worksheet?

An unshared worksheet is a SQL worksheet that has a dedicated database connection behind it. These come in handy when your database connection is busy doing OTHER things.

The ‘problem’ with Ctrl+Shift+N is that it only works if you’re on the main/original worksheet. You CAN’T open a new unshared worksheet from an existing unshared worksheet. To keep these connections ‘private’ or exclusive to the worksheet, we do ‘special things’ in the code. And as a result, you can’t spawn one unshared worksheet from another one.

But

But, you can do THIS.

Enable in preferences:

This applies to SUBSEQUENT worksheets opened on a database, not the first one.

So when you connect, you get a worksheet by default. Use it. Go crazy. Run a run long running query, and need another? Ctrl-Shift-N will get you a new worksheet, and a new connection.

Go crazy some more. Need another worksheet/connection?

Alt-F10.

Should work wherever you are.

Then pick your new connection – this dialog is keyboard-able.

Each worksheet gets its own connection.

Close ‘Em, or Suffer the Wrath of your DBA

Connections aren’t free. They require server process(es), database resources, and more. Abuse the system, and you will have to turn in your db credentials. And then you can’t have fun writing SQL anymore.

Tell Others About This Story:

Leave a Reply

Your email address will not be published. Required fields are marked *