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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,