![]() ![]() Once you hit that key sequence, SQL Developer will fire up another window to that same instance so you can work up your next query to save the world (or build that spreadsheet for your boss.) Trick: Default New Worksheets as ‘Unshared’Įvery worksheet you open will be unshared – minus the default worksheet you get on a connection. If you can’t remember this, then you can always pull it up in the SQL Developer Preferences window, on the ‘Shortcut Keys’ page. ‘N’ probably stands for some weird coder jive like ‘Nero’ or ‘Narnia’, but I’m going with ‘New’, as in ‘New Worksheet.’ Hurry up already, I gotta go! Here is the keyboard shortcut you need to memorize for the Worksheet If you don’t use statement delimiters, you may have to select the text you want to execute first. Use statement delimiters ( ) to end your queries, then you can use Ctrl-Enter to auto-execute the query at cursor. text FROM all_objects b, all_source dĭon’t even bother looking at the plan for that, it’s nasty, and that’s kind of the point really! Anyways, it takes about 30 seconds to run, and I need to do other things while I’m waiting for that to come back.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |