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 […]
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 […]
Quick Filtering Objects in the Schema Browser
Today’s post is brought to you by a new request to the Exchange this week. They wanted to be able to quickly filter a list of objects without having to open a dialog to do it. For a dynamic browsing of databases with a lot of objects it would be nice to have a textbox […]
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!) […]
If You Oracle Then You Should Twitter Too
Kellyn PotVin-Gorman and I have delivered a social media talk at the RMOUG Training Days Conference two years running now. We have fun doing the presentation, because we have fun being active on social media. We want you to not miss out on what we get out of it every day. This morning I saw […]
A Quick 4.1 Trick: SET SQLFORMAT
One of your favorite SQL Developer ‘tricks’ is the ability to pre-format query output. So instead of getting standard output back, maybe you want query results to come back as CSV. But using that requires you to add code to your existing SQLs. Maybe instead it would be cool to set the overall script output […]
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 […]
Oracle SQLcl Slidedeck: Overview of our new command line interface
This is a similar version of the content I presented to some internal folks here at Oracle last week. I thought you might enjoy it as well. I’ve ‘optimized’ it for Slideshare – meaning that there are NO animated GIFs, which is sad, but it does read better this way. There’s a YouTube video inside […]
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 […]
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. […]
‘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 […]
Oracle SQL Developer: The Definitive Guide to Completion Insight
Can SQL Developer help me finish my SQL or code? Probably. Here’s a quick showing of what it’s capable of. Need more help on the syntax? Click on the keyword in the last two examples, and you’ll be taken to Oracle DOCS syntax pages for that command. Not working? A few things to remember: mind […]
Oracle SQL Developer and the Oracle Database Schema Service
The Cloud! You may have heard a few things about Cloud services and Oracle over the past few years. What I’m going to talk about today is our Database Schema Service offering. It’s what it sounds like, pretty much. On a kick-butt Exadata box, you get your own schema in a database that we take […]
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 […]
Drawing Foreign Keys & Relationships in SQL Developer Data Modeler
It’s all in the wrist, literally. You need to know where to start and where to finish. And you need to click ‘just’ right. Watch the animation and see what I’m talking about. So a few KEY things Start with the ‘parent’ Click on the table and ‘let go’ Now go and click on your […]
Twitter
RSS
GooglePlus
Facebook