ThatJeffSmith

Tag: sqldev

Java 8 on a Mac with SQL Developer 4.1

I ran into a few dramas getting SQL Developer 4.1 on my MacBook Air going earlier today. It boiled down to convincing SQL Developer to find and use the proper JDK on OS X Yosemite. So just in case it’s not me out there, here’s what I had to do. Unless you already have Java […]

Similar Posts by Subject Areas: , , , , , ,

SQL Developer 4.1 – Instance Viewer

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, which was released as an Early Adopter yesterday. Some updates…Jan 31, 2015 The DBA feature I want to talk about today is the Instance Viewer. Well, technically the window is […]

Similar Posts by Subject Areas: , , , ,

SQL Developer Formatter: Left Aligning Columns in a SELECT

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 […]

Similar Posts by Subject Areas: , , ,

Adding Columns to a Table in SQL Developer Data Modeler: Honor Column Order?

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, […]

Similar Posts by Subject Areas: , , , , , ,

A Quick Tip on Finding Data in Oracle SQL Developer

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 […]

Similar Posts by Subject Areas: , ,

Oracle SQL Developer Look and Feels

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” […]

Similar Posts by Subject Areas: , , , , ,

Oracle SQL Developer Code Reports

It’s so much more fun to watch users demo and brag about your software than it is to get up and do it yourself. For one thing, it means a lot more coming from real people than it does coming from someone PAID to talk it up. Today, about 40 of us in Raleigh/Durham watched […]

Similar Posts by Subject Areas: , , ,

Explain Plan ‘Notes’ in Oracle SQL Developer

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 […]

Similar Posts by Subject Areas: , ,

Videos: Oracle Open World 2014 SQL Developer Talks

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 […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , , ,