The SQL Developer team has been steadily adding features tailored to the DBA since the version 3.0 release. This steady march continues with version 4.1. The DBA feature I want to talk about today is the Instance Viewer. To open it, you’ll need: SQL Developer 4.1 JDK 8 – this screen uses Java FX, and it’s designed with Java 8 a very high privileged account – I’m using SYS b/c I can Pst! We updated…
Go get it. Then come back here and read a couple of things. it REQUIRES Java 8 it’s not production ready – send feedback to the Forum not to Support Two new features to help you get started. SQL Formatting in the Worksheet Like the /csv/ formatting ‘hints’ you can add to your statements? Well now, you can just toggle that output mode for an entire session. You ‘unset’ the formatting by using the ‘set…
Question: I can’t figure out how to make a column list align like this (underscore = space): _SELECT_column1 ______,_column2 ______,_column3 ______,_column4 ___FROM_table The closest result that the formatter produces is: _SELECT_column1, __column2, __column3, __column4 ___FROM table where all column names start at text position 3… My answer isn’t going to be perfect, but it’s going to get the questioner, and you, very close to what you’re looking for. Set These Formatter Preferences One comma per…
I have an employees table. Because it’s 1984, HR has decided we need to know Twitter handles, Facebook pages, and who knows what else. So let’s add it to our table. The dialog by default puts new columns at the bottom of the table. We’ll see why in just a moment. On a side note, we’re not super fond of these ‘arrow’ buttons to launch the compares. I don’t think they’re as intuitive as they…
Oracle SQL Developer is a tool. My general rule for using tools boils down to – if the tool is making it harder to do the job you’re using it for, you’re either ‘doing it wrong’ or you have the wrong tool. Sorry for the long setup, but I had someone approach me at the DOAG conference in Nuremberg this week with the following request: I cannot really use your tool to work with my…
Looking at endless spreadsheets or grids of data can make one’s brain a bit fuzzy. SQL Developer makes it easy to spot the bad data you’re looking for. Hit Ctrl+F in a grid. Type your search term. If you’re going to be looking for this data going forward, check the ‘Persist Highlight’ box. So for example, if I’m getting ready to demo some Tips & Tricks and I want to call out the very nice…
My work machine is a Dell laptop running Windows 7. My home machine is a MacBook Air running OS X Yosemite. 98% (made up number) of the posts on this site were written using my Windows machine. But now that I’ve discovered that my SnagIt license is also valid on my Mac, I’m trying to do more writing there. It’s also a good way to see how the other 10% of our users work, live,…
SQL Developer is a Java Swing desktop application – surprise! We support a native operating system ‘look and feel’ and also ship with an Oracle look and feel (LnF). The architecture of Swing is designed so that you may change the “look and feel” (L&F) of your application’s GUI (see A Swing Architecture Overview). “Look” refers to the appearance of GUI widgets (more formally, JComponents) and “feel” refers to the way the widgets behave. The…
Oracle ACE Director, BI/data/all things cool and extraordinaire, Stewart Bryson had a bit of a complaint about our favorite tool today. He wants Explain Plans in SQL Developer to show the same notes you can see in SQL*Plus… @thatjeffsmith See… no execution… and the notes. With one little statement. pic.twitter.com/w3GYkIPaDY— Stewart Bryson (@stewartbryson) November 4, 2014 So how do you see the Explain Plan notes in SQL Developer? The database writes that plan meta data…
For this year’s Open World, SQL Developer got lots and lots of love from the conference organizers and keynote speakers. I think SQL Devleoper was mentioned, demoed, or both in at least 3 of the executive keynotes. We had many successful, and FULL, hands on labs – led by the lovely Ashley Chen. And our SQL Developer talks were in the top 10 most popular in the Database/Tools tracks. Some Steven Feuerstein guy beat me…