ThatJeffSmith

Category: SQL Developer

Charting Values over Time in a SQL Developer Report

Today’s post is courtesy of this question from a reader: Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted? The answer is ‘Yes!’ I’m going to use HR.EMPLOYEES to give me my data. I start with… SELECT Hire_date, Salary FROM Hr.Employees ORDER BY Salary […]

Similar Posts by Subject Areas: , , ,

Multiple Ways to Edit in SQLcl

If you know how to edit your code in SQL*Plus, you already know how to do it in SQLcl. But I get asked this a lot, do you support EDIT? Do you support CHANGE? And what does SQLcl offer over those? So let’s tackle the old and then the new… C/Old/New SQL*Plus has the C[HANGE] […]

Similar Posts by Subject Areas: , , ,

Showing TYPE’d Column Values in SQL Developer

Someone on the innerwebs asked how to show the data inside their user defined TYPE’d column in a table when querying it with SQL Developer. Here’s their code: CREATE OR REPLACE TYPE ANSCHRIFT_T AS OBJECT (STRASSE CHAR(12), HAUSNR CHAR(3));   CREATE TABLE VERTRETER(V_NR NUMBER(4) PRIMARY KEY, ANSCHRIFT ANSCHRIFT_T);   INSERT INTO VERTRETER VALUES (1, ANSCHRIFT_T(’TESTWEG’,’14’)); […]

Similar Posts by Subject Areas: , , ,

Getting Your DBMS_OUTPUT Super Fast

SQL Developer has a DBMS Output panel you can open and add to your desktop. You then add a connection you want to poll, and then you enable polling. It’s about 4 clicks. If you want to increase the default buffer size from 20,000 characters, then that’s a few more clicks and keystrokes. A friend […]

Similar Posts by Subject Areas: , ,

Customizing SQL Developer Toolbars

We already have some pretty Spartan toolbars. We aim for fewer buttons, not less. But maybe you want to go SUPER Spartan. Even fewer buttons! Yeah, you can do that. View > Show Toolbars > Customize Main Toolbar > Customize I’m going to take a few things off the main editor and data modeler toolbars. […]

Similar Posts by Subject Areas: , ,

SQL Developer Looks Cool

I sometimes get a double-take when I do a blog post or tweet or show a picture of SQL Developer running on my Mac. My Macbook is my personal machine: I don’t normally do live-demo’s on it, but I almost always do my blog posts and screenshots from there. For official webcast stuff and conferences, […]

Similar Posts by Subject Areas: , , ,

Can Oracle SQL Developer do that?

Here’s a quick run-down of FAQ’s I get when doing presentations or demos. Can SQL Developer… Extend a tablespace? Yes. You can edit an existing data file or add a new one. We’ll also show you the SQL that’s going to be used so you can copy it to run in SQL*Plus or wherever. And […]

Similar Posts by Subject Areas: ,

Why DESC When You Can INFO in Oracle SQLcl?

INFORMATION is a new command available in SQLcl, a command-line interface to Oracle Database. [email protected] >help information INFORMATION ——–   This command IS LIKE DESCRIBE but WITH more details about the objects requested.   INFO[RMATION] {[schema.]object[@connect_identifier]} INFO+ will SHOW COLUMN statistics   [email protected] > It’s available for tables and views, of course. Here’s a table. […]

Similar Posts by Subject Areas: , ,

Viewing BLOBs in SQL Developer as Text

I have talked about how to preview BLOBs (Binary Large Objects) as pictures… But someone on Stackoverflow asked how to read a BLOB value if it had text. So I spooled the content of my EMPLOYEES table to a txt file, as CSV, and then loaded that to a table as a BLOB. Then I […]

Similar Posts by Subject Areas: , , ,

2 Reports You Might Enjoy in Oracle SQL Developer

I keep telling people our reporting functionality is probably the most powerful AND overlooked feature in SQL Developer. Today I’m going to share 2 reports that I frequently forget about, that you may enjoy. Finding Unindexed Foreign Keys We all know this should not happen. We all know it eventually happens. Here’s a report to […]

Similar Posts by Subject Areas: , , , , ,

What The Format? Making Your Code Pretty in SQL Developer

This post is a tease. It’s also a request. Send me your ugly code. In version v4.2 of SQL Developer – to be released in calendar year 2016 – we’ll be offering a new formatter for your SQL and PL/SQL. It’s got a completely new engine under the hood. It’s faster. It’s more efficient. And […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: ,