ThatJeffSmith

Category: SQL Developer

Formatter Improvements in v4.2

The old formatter, the code that’s used to format your code from v1 to version 4.1 was based on some pattern matching code and expressions. It was very limited, and didn’t like a lot of syntax and coding styles common in Oracle code. It also wasn’t very flexible. So we built a new engine. One […]

Similar Posts by Subject Areas: , , ,

4.2 Tweak, Working with Views

Someone said we should make the view source searchable, and that we should show any errors on a view. Actually, it might have been a few dozen of you. A reader reminded me that we actually implemented this in v4.2. Code Outline I’ll go into more depth here next week when I’m back from Open […]

Similar Posts by Subject Areas: , , , ,

New Feature: Drag and Drop Object To Copy Them to Another Oracle Database

In both v4.1.5 and v4.2, you can now select objects from your database tree, and drag them to another connection to have them copied. The source can be: a MySQL, DB2, SQL Server, Sybase, Terradata, or other 3rd party supported RDBMS an Oracle Database The destination can be: an on-premise Oracle Databaes an Oracle Database […]

Similar Posts by Subject Areas: , ,

SQL Developer Release Party: Download all the Things

Oracle SQL Developer Command Line (SQLcl) is now officially available. (Download) Thanks to the many of you who provided feedback and helped us make this ready. We plan on very regular updates, every 60-90 days, so the fun hasn’t stopped. Oracle SQL Developer v4.1.5 is now officially available. You can now drag and drop objects […]

Similar Posts by Subject Areas: , ,

Extending Oracle SQL Developer Command Line (SQLcl) with JavaScript: Single Record Viewer

Oracle SQL Developer Command Line (SQLcl) is the full name for what we’ve been calling, SQLcl. Have you seen the video? It’s only 8 minutes and will catch you up on just what SQLcl is. Anyways, there’s a ‘new’ command called SCRIPT that I want to show you today. I say ‘new’ because we added […]

Similar Posts by Subject Areas: , ,

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