ThatJeffSmith

Tag: sqldev

SQLDev at Oracle Open World 2016

It’s already almost that time of year again. Which means I need to let you know what you can expect from our team at the world’s largest Oracle event – Oracle Open World. Sessions start on Sunday, September the 18th – but the fun with our team starts on Saturday morning. Kris Rice and I […]

Similar Posts by Subject Areas: , ,

Designing Foreign Keys, PT II

I say designing, because I’m going to be talking about how to do this in SQL Developer Data Modeler. And I say Part Two, because in a previous post I showed how to draw a foreign key in your relational design. This post discusses how to control the generation of the foreign key column: to […]

Similar Posts by Subject Areas: , ,

PL/Scope Support

The PL/SQL team is always reminding me to talk about PL/Scope. And I got to the point where I needed to remind myself, so I added this slide in all of my PL/SQL themed talks. Yet, I have apparently forgotten to blog about it. Oops. [Docs] PL/Scope is a compiler-driven tool that collects data about […]

Similar Posts by Subject Areas: , , , ,

Shopping for CSV with SQL Developer’s Cart

A friend of mine asked how he could generate CSV for 40 Oracle tables in Oracle SQL Developer. He could of course use Tools > Database Export to accomplish this. But, it was always the same 40 tables. And using the object picker in the wizard can get tedious, especially if it’s the same 40 […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer 101: The Very Basics

We spend a lot of time here talking about tips, tricks, and cool things that you might have missed. These posts generally all assume you’ve been around the Oracle Database block. But many of the folks that ultimately end up here, have NEVER touched an Oracle Database before. This post is for you. You have […]

Similar Posts by Subject Areas: , ,

Oracle SQLcl, Why?

Oracle SQL*Plus has been around since 1985. It does what it does, and it does it well. SQL Developer has been around since 2006. It’s become the de facto IDE and GUI for the Database. There was an opportunity to build something new that could take the command line interface and enhance it to meet […]

Similar Posts by Subject Areas: , ,

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: , , ,

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: ,