ThatJeffSmith

Tag: sqldev

Exporting SQL Developer Reports/Grids to PDF

You can save query results or any other grid in SQL Developer as a PDF. You don’t get much in terms of saying how the generated PDF should look – Said PDF file: But I have some important info in here, and it should look a bit nicer. Save Your Query As A Report And […]

On Installs and Updates of SQL Developer

As we get nearer to releasing our next update for Oracle SQL Developer, there are a few FAQ’s I’d like to answer. When IS version 4.1 going to be available? Soon. Will there be a Windows download available that includes a JDK? Yes, there will be a 64-bit bundle available. Why are you making us […]

Generating Object DDL Scripts with Drop Statements

Is there a way for SQL Developer to generate a DROP statement when exporting the DDL for a table? Yes. The drop preference will be applied when generating the DDL for scripting purposes, but not for the table editor. So to get the table CREATE DDL script with a DROP TABLE command, right-click on your […]

How to Share Reports

Reports are one of my favorite features. If you don’t use them in SQL Developer, please read this. The user interface for user defined reports is very simple in SQL Developer. Maybe even, too simple? Sometimes I tell folks to save and/or copy their reports around. And it’s not exactly apparent how to do this […]

SQL Developer: Wearing of the Green

In honor of today’s holiday, a hat tip to our Irish friends! Spot the places I’ve configured SQL Developer to show green I can spot 7 different spots in the above screenshot where I have configured SQL Developer or manipulated the output to show the color green.

Customizing File Extensions for Your PL/SQL Code

You may wish to store your PL/SQL code in files with file extensions other than our defaults. We ship with .klr, .pkb, .pkh, .pks, .plb, .pls as associated file types for our PL/SQL editor and for opening said files on your machine with SQL Developer. But maybe at XYZ Incorporated, you keep your package bodies […]

Continued Improvements to [Code] Completion Insight

A few weeks ago I published a story highlighting all of the different ways SQL Developer can help you with your code. That post generated a lively discussion around this: Pre Version 4.1 Let’s try that again: Version 4.1 Early Adopter 2, specifically We’re also making sure to sort the local schema objects ALWAYS to […]

SQL Developer Data Modeler Screenshots

I’ve taken a TON of screenshots of both SQL Developer products to demonstrate features. I was playing around with Flickr to see if there was a better way to re-purpose this content other places. Here’s what that COULD look like. I have a few hundred more to add to this photo album. This is just […]

Why Is My SQL Slow & Go Faster Features

Yesterday I made my first presentation ever at the annual Hotsos conference. The topic: “All of the Performance Tuning Features in SQL Developer.” It went pretty well, and I’d like to share those slides now with y’all: Tuning & Diagnostics Features in Oracle SQL Developer from Jeff Smith Easier to Read Autotrace Execution Plans Apparently […]

Reporting Quick Tip: Dial Gauges

Everyone likes pictures. I would never create a report that didn’t have at least one chart in it. You just can’t risk busy people glancing at your reports and not coming away with the key information you’re trying to impart. We have lots of chart types in SQL Developer – 50+ in version 4.0. But […]

Quick Filtering Objects in the Schema Browser

Today’s post is brought to you by a new request to the Exchange this week. They wanted to be able to quickly filter a list of objects without having to open a dialog to do it. For a dynamic browsing of databases with a lot of objects it would be nice to have a textbox […]

Introducing our Weekly Oracle Database Development Web Series

Hi, I’m Jeff Smith. You might remember be from such self-help videos as “Code is Self-Documenting”, and “We Let the End Users Test Our Code.” Thanks for humoring me as I pay tribute to one of my favorite comedians, Phil Hartman as Troy McClure on The Simpsons…but I digress. Starting this week (Wednesday, February 25th!) […]

Related Posts Plugin for WordPress, Blogger...