ThatJeffSmith

Tag: sqldev

SQL Developer Q&A from ODTUG Tips & Tricks Webcast

Another great webcast yesterday – if you’re a paying member of ODTUG you can watch the show for yourself in their archives. If not, you can get my slide deck off of SlideShare. About 150 of you brave souls sat through an entire hour of me talking and then 10 more minutes of Q&A. We […]

SQL Developer: BLOBs and the External Editor

We already know how easy it is to view images and plain text with the BLOB editor, yes? But what if I have in my column a bunch of PDFs stored? I want to see that stuff without having to save the file, finding it, and then opening it. Why can’t I just automatically open […]

SQL Developer Quick Tip: Reordering Columns

Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data? Don’t do that! Instead, just right-click on the column headers, select ‘Columns’, and reorder as desired. Then move up the columns you want to see first… This will […]

Oracle SQL Developer Data Modeler 4 and Comment Display

A new feature in Oracle SQL Developer Data Modeler is the ability to display table and view comments directly in the ERD. So I can go from this: Normal Relational Diagram to Relational Diagram with Comments to Relational Diagram with Comments ONLY Now the cool part is that I don’t have to pick. I can […]

Oracle SQL Developer 4 and Auto Spec – Body Toggles

I’ve been running version 4 for so long, that I have trouble remembering if some features are new to version 4. Well, here’s a simple feature that IS new to version 4 that I think our PL/SQL friends will appreciate. Say that you’re looking at a PACKAGE SPEC member, like a FUNCTION, and I want […]

Unshared Worksheets in Oracle SQL Developer 4

My alternate title for this post was How to get the DBAs’ attention with lots and lots of connections in her database. But I decided to go with substance over style instead. Anyways, let’s talk about connections in SQL Developer for a bit – you know you need the refresher! By default, connecting to a […]

How to Compare PL/SQL and SQL in Oracle SQL Developer

This question has come up a few times recently. One person asked how to compare 2 SQL statements at Open World. In fact, they claimed if I could show them how to do it, it would make the trip to San Francisco worth every penny. Don’t be surprised they left extremely satisfied Then just yesterday, […]

Oracle SQL Developer and the Dreaded Connection Busy Message

So you’re minding your own business, doing your work, and you click in your favorite Oracle Database IDE. Do you get what you asked for? No! Instead, you are rewarded for your troubles with this puzzling and frustrating message. Abort? Try again? Busy? The Long Answer When you connect to a database in SQL Developer […]

A Few Thoughts Regarding Oracle Open World 2013

Another busy, crazy, awesome week is behind us. I’m going to call it a success, but before I completely file it away, I wanted to share a few quick thoughts, and say thanks to a few people for their continued support. Sunday SQL Developer Golden Gate Fun Run We had about 20 people show up […]

SQL Developer 4 and the Oracle Diagnostics Pack

Oracle Database Enterprise Edition customers have the option of extending their functionality set via various optional ‘packs.’ One of the most popular packs is the Oracle Diagnostics Pack. Funny, most people call it the ‘Diagnostic’ Pack, but it’s technically known as the Diagnostics Pack. Anyways, the pack includes a LOT of features. You can see […]

Oracle SQL Developer v4EA2 Is Now Available

EA1 dropped in July. Now here we are a little more than a week before Oracle Open World and we are making Early Adopter 2 of Oracle SQL Developer version 4 available for you to download and provide feedback. There’s two big things you need to know about: About 500 bug fixes Support for ADDM/AWR/ASH […]

10 Things You Probably Didn’t Know About Oracle SQL Developer

You think you know Oracle SQL Developer. And you probably know it better than the average user, especially if you’re a subscriber to this blog But I’m betting there’s a few key things you’ve overlooked. We’re going to fix that today! Skip Ahead to the Slideshare Version 10. We’re not the new kids on the […]

Oracle SQL Developer 4: A Tweak With Table Filters

In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you. A few folks have asked that we not be so aggressive with the ‘help’ here. And I wholeheartedly agree. So in version 4… If You Want Help, […]