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... [Read More]

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 will be... [Read More]

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. Animated GIF showing how to draw a foreign key in Oracle SQL Developer Data Modeler. This post discusses... [Read More]

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,... [Read More]

PL/Scope Support

I forgot to blog this! 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... [Read More]

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 debugging them. If you... [Read More]

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! (adsbygo... [Read More]