ThatJeffSmith

Category: SQL Developer

Having Fun With Prompts – and Saving Yourself from Mistakes

In SQL Developer we have color coded connections. This was added, not because we like Christmas trees and all the pretty lights, but because sometimes you need a reminder of what database you’re on. So you don’t TRUNCATE stuff, accidentally. Visual cues won’t prevent all mistakes, but they sure help. With SQLcl, you have the […]

Similar Posts by Subject Areas: , , , , ,

Client Side Filtering in the Grids

Just what it sounds like – you ask to see LESS data in a grid, and we don’t re-query the database. Instead, we filter only on the client-side. This means it’s FAST. No asking the database to run the query again. This also means you might not be getting the WHOLE truth, or the latest […]

Similar Posts by Subject Areas: ,

Unicode and Oracle SQLcl…on Windows

I have an UMLAUT table. Pretty simple really… CREATE TABLE "HR"."UMLAUT" ( "CHARACTERS" VARCHAR2(2) ) ; REM INSERTING INTO UMLAUT SET DEFINE OFF; INSERT INTO UMLAUT (CHARACTERS) VALUES (’Ñ’); INSERT INTO UMLAUT (CHARACTERS) VALUES (’Ä’); INSERT INTO UMLAUT (CHARACTERS) VALUES (’Ñ’); COMMIT; Looks great in SQLDev, but not so much in SQLcl… Everything is UNICODE […]

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

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,