ThatJeffSmith

Tag: sqldev

SQL Developer Data Modeler Screenshots

I’ve taken a TON of screenshots of both SQL Developer products to demonstrate features. I was playing around with Flickr to see if there was a better way to re-purpose this content other places. Here’s what that COULD look like. I have a few hundred more to add to this photo album. This is just […]

Similar Posts by Subject Areas: , ,

Why Is My SQL Slow & Go Faster Features

Yesterday I made my first presentation ever at the annual Hotsos conference. The topic: “All of the Performance Tuning Features in SQL Developer.” It went pretty well, and I’d like to share those slides now with y’all: Tuning & Diagnostics Features in Oracle SQL Developer from Jeff Smith Easier to Read Autotrace Execution Plans Apparently […]

Similar Posts by Subject Areas: , , , , ,

Reporting Quick Tip: Dial Gauges

Everyone likes pictures. I would never create a report that didn’t have at least one chart in it. You just can’t risk busy people glancing at your reports and not coming away with the key information you’re trying to impart. We have lots of chart types in SQL Developer – 50+ in version 4.0. But […]

Similar Posts by Subject Areas: , , , ,

Introducing our Weekly Oracle Database Development Web Series

Hi, I’m Jeff Smith. You might remember be from such self-help videos as “Code is Self-Documenting”, and “We Let the End Users Test Our Code.” Thanks for humoring me as I pay tribute to one of my favorite comedians, Phil Hartman as Troy McClure on The Simpsons…but I digress. Starting this week (Wednesday, February 25th!) […]

Similar Posts by Subject Areas: , , ,

Stop Doing That! – In Oracle SQL Developer

One of the coolest bits of The Matrix, was the ability for the main characters to ‘download’ new skills or objects into their virtual reality. Like Neo could learn Kung-Fu with a simple button click. Today, I want all of you to take the (Oracle) Red Pill, and download your SQLDev knowledge pack. These are […]

Similar Posts by Subject Areas: , ,

Are Invisible Columns Really Invisible?

Today’s question: How are invisible columns treated with DESC, INFO and the GUI equivalent? Super quick, an INVISIBLE column is one that the user doesn’t see. They won’t be able to access it unless they know about it. Security by obscurity? No. Tom Kyte shows a few examples of the features usefulness, especially when adding […]

Similar Posts by Subject Areas: , , , , , ,

SQLcl Commands: Info & Info+ – The New DESC?

We put out a HUGE update for our new SQL*Plus-style command line interface for Oracle Database. Forget how to install it, or how to connect: see the movie! Things that people really like to do in SQL Developer is pull up the object browsers to quickly see the things that a simple DESC doesn’t show. […]

Similar Posts by Subject Areas: , , ,

‘Modeling’ View Dependencies in SQL Developer Data Modeler

Today’s question: Please let me know how can I represent relation between view and base table in ER diagram created using sql datamodeler version4. So I know what the person is getting at here. They want to see the dependencies. Generally speaking, there are no actual relations between views and tables. Exception: you CAN define […]

Similar Posts by Subject Areas: , , , , ,

Oracle SQL Developer Meets SQL*Plus?

If you weren’t paying attention over the Christmas/Winter break, it’s very possible that you haven’t heard about our new project. You can find it on the SQL Developer version 4.1 Early Adopter download page.. If you’re not into reading so much, we have 7 or 8 blogs on the subject out there, you can just […]

Similar Posts by Subject Areas: , , , ,

Exporting a PL/SQL Package Just the Way Monty Likes in SQL Developer

Got a quick question from my favorite President today. So basically, Monty was asking how to get a PL/SQL Package Spec & Body to: a single file with a SET DEFINE OFF with the schema prefix in the CREATE or REPLACE Now, there’s more than one way to get one or more objects in the […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,