There’s nothing wrong with the Connection Tree. You don’t have to Test your connection first, you can just ‘Save’ it, if you’re confident 🙂 5. We don’t ‘nuke’ the existing connection, we’l instead create a new one with the new name, and the original one remains. Just edit an existing connection, give it a new name. You want to add a second connection to the same database. I’ve seen people do this so many times…you have a connection to one database. You can nest as many levels as you want, and you can do this on the DBA connection panel, too! 4. The easiest way to do is this is to add them to a folder, or even subfolder. The first is, give your connections GOOD names. I was using the mouse to execute the script, but F5 is faster. Now, sometimes you’ll want that running log. I use this all the time, and so does Franck!Īs you’re testing a snippet of code, you’re going to be making changes and running it, over and over again. Avoid the ‘Clear’ button, just use Clear Screen If you don’t use statement delimiters – the semicolon – you will need to highlight your code first. I was watching my co-worker, write her statement, then circle back, select the text, then use the ‘Execute’ button on the toolbar.Īnd if you’re using statement delimiters, or if you only have a single statement in your worksheet, it’s completely unecessary. What are the very, very basics of the UI/UX in SQL Developer? End of day, Franck just pushed me to ‘get busy blogging, or get busy dying.’ 1. I ALSO wanted to get down to the lowest possible level of this concept. This post will be over in just 2 more minutes 🙂

You can watch it now of course, but it’s about 17 minutes long. This feeling, or reaction was the driving force behind my “ SQL Developer, You’re Doing it Wrong” video. It bothers me to watch people do stuff less efficiently than they could be. watching a co-worker use SQL Developer over Zoom.This post was inspired by two simple events –

Oracle sql developer basics