ThatJeffSmith

Category: General

Ask Tom…and Chris and Connor

If there is a Madonna or Prince in the Oracle Database world, that would be Tom. You know, people that are known solely by their first name. Of course there’s also Larry, but from a pure database tech perspective, Tom has satiated the curiosity of developers and DBAs for the past couple of decades. If […]

Similar Posts by Subject Areas: , ,

TABs in Your Code?

Not to start a religious war, but white space in your code can cause havoc when you’re doing code compares and versioning. Some folks like tabs, others prefer to control how their code looks regardless of the editor’s tab display options. From what I can tell, SQL Developer’s code editors won’t even let you insert […]

Similar Posts by Subject Areas: , , , ,

SQLcl: ANSICONSOLE and Column Header Formatting

Question: Why is SQLcl truncating my column header names? It doesn’t do it if I use SET SQLFORMAT ANSICONSOLE though… Answer: Because, SQL*Plus. Longer Answer: SQLcl follows the SQL*Plus rules. And in this case, the rule is: The default width of CHAR and VARCHAR2 (VARCHAR) columns is the width of the column in the database. […]

Similar Posts by Subject Areas: , ,

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

Ask Today for Training/Conferencing Tomorrow

It’s that time of year again. You’re jealous from hearing all about that fabulous conference your co-worker or Facebook buddy just got back from. You could NEVER make it a conference. Your company just doesn’t do that. If you want to go to a top-tier Oracle user group or industry conference next year, it’s time […]

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

Debugging PL/SQL Collections Revisited

I talked about using the debugger to inspect a collection in PL/SQL using SQL Developer a few years ago. It’s been so long in fact that when Steven asked if I had a post on it, I said ‘no.’ We had gotten a question from a reader on how to look at collections while you’re […]

Similar Posts by Subject Areas: , , ,

Bump Your Fonts Up Already

I try to keep my fonts ‘big’ – for folks reading my posts and for folks attending my sessions. I do lots and lots of live demo’s, and there’s a lot of code on the screen to keep track of. But I’ve generally not followed my own advice when working in a cmd shell. Oops! […]

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

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,