Top 10 Posts of 2016

thatjeffsmith SQL Developer 0 Comments

Tell Others About This Story:

Happy 2017!

Here are your 10 favorite posts from last year.

1. Exporting Multiple Tables to Multiple Excel Spreadsheets

Want 6 tables’ worth of data to go to single Excel file? Or one table per file? Here’s how to do that.

Ta-da, again.

All of your tables, in a single Excel file.

2. Oracle SQL Tuning Advisor and SQL Developer

Own the Tuning Pack? Have SQL Developer? You should be using that then.

BONUS POST: Viewing your automatic SQL Tuning Advisor Job Reports.

Using this toolbar button will create a tuning advisor task and display the results below.

Using this toolbar button will create a tuning advisor task and display the results below.

3. Can Oracle SQL Developer Do That?

FAQ’s I get when doing presentations or demos…

Can it extend a tablespace?

Add Datafile...that sounds about right.

Add Datafile…that sounds about right.

Yes. Yes, it can.

4. Oracle SQLcl, Why?

So we built a new command-line interface for Oracle Database. Why did we do that?

BECAUSE IT'S AWESOME

BECAUSE IT’S AWESOME

5. A Place to Learn Oracle, No Setup Required

Want to learn Oracle Database? Don’t want to install anything?

You’re in luck!

type stuff, hit the 'Go' button, see the output - errors, results, GLORY!

type stuff, hit the ‘Go’ button, see the output – errors, results, GLORY!

6. SQL Developer Features Every DBA Should Know About

Are you a DBA? Do you use SQL Developer?

Then read this post already.

Instance Viewer can flip from storage/IO stuff to Top SQL.

Instance Viewer can flip from storage/IO stuff to Top SQL.

7. Make SQL Developer Run Faster

Want to speed things up a bit? Here are a few tips.

Tools  > Features. Uncheck stuff.

Tools > Features. Uncheck stuff.

8. SQL Developer 101: The Very Basics

New around these parts? Want help getting started?

XE is the default SID because we have a free version of Oracle, eXpress Edition whose SID is 'XE'

XE is the default SID because we have a free version of Oracle, eXpress Edition whose SID is ‘XE’

9. SQL Developer Looks Cool

Ok, so I’m a bit biased. But you can do a bit of tweaking to make it fit your needs and personal design aesthetic.

I went completely custom, but I can't really remember why...

I went completely custom, but I can’t really remember why…

10. What the Format? Making Your Code Pretty

Code formatters. We have them for SQL and PL/SQL. We’re doing a TON of work on it for version 4.2. But here’s a look at our current offering.

Even better: in version 4.2 EA2 – submit your own code sample to SET/CONFIGURE the formatter to make it work the WAY YOU WANT IT TOO #WorkInProgress.

Type code, as the formatter sees 'stuff' it changes the formatting options - these are highlighted in Green so you can see what's changed.

Type code, as the formatter sees ‘stuff’ it changes the formatting options – these are highlighted in Green so you can see what’s changed.

Tell Others About This Story:

Leave a Reply

Your email address will not be published. Required fields are marked *