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…
I don’t think the word synonym is especially hard to spell, I just think it’s hard for my fingers to type it correctly. I’ve incorrectly typed it often enough that muscle memory is working against me. I run into a lot of developers that never learned to type, which sounds weird to me – like a plumber who doesn’t like wrenches…but anyways, if you need a bit of help, Oracle SQL Developer feels your pain.…
I’ve shown how to drag and drop database tables from Oracle SQL Developer into a design. But I’ve never done a start-to-finish, blow-by-blow post on how to import your existing database objects into a data model with SQL Developer. So let’s do that now. Warning: Lots of pictures coming up. Want to import from SQL Server (or DB2) instead? Check out this great post from Oracle ACE Director @kentgraziano on how to get SQL Server…