I wrote recently about using REST to upload a file to your table with ORDS. I want to extend that and share more code. I want you to see how to not only load the pics, but then how to get a collection of items, with links to those items, and in this case, also links to the media (pics) …
Real Time SQL Monitoring in Oracle SQL Developer v4.2
People seemed to like the Instance Viewer we built for version 4.1. So we wanted to use similar technology (Java FX) to build a new interface for the Oracle Database Tuning Pack’s Real Time SQL Monitor. So we did. If you don’t have EM Express or Enterprise Manager available or handy, you can get the report in all it’s live, …
Your Favorite Oracle SQL Developer Trick, Animated.
I had the privilege of spending a few days in Argentina and Brazil last week presenting on all things SQL Developer. It turns out, they enjoy the very same tricks that folks everywhere else do – especially the split editors and multiple tab groups. Here’s what I’m talking about. This works for tables too! So that’s cool. Now let’s show …
Demo: AutoTrace – Generate Hints and Compare Different Execution Plans & Stats
For some reason I procrastinated setting up my video software on my new work machine. Big mistake. I put together this animated GIF to show some new things in version 4.2: Updated formatter – better support for ANSI joins Opening objects referenced in your execution plans Inserting Hints Not new but underutilized: how to compare plans/AutoTraces One Last Thing… …don’t …
Get Help, Just Hit TAB
You’re at the command-line, you need to add a data file to your tablespace. You get most of the way through it, and you forget what’s next, doh! In SQLcl, you can just hit the TAB key, and we’ll help you with the next keyword. So not only do we have tab-completion for object and column names, we also look …
Just another GIF: Debugging PL/SQL
Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of this for all of my …
Your Most Requested SQL Developer Demos
The team just got back from another Oracle User Group Conference, or I should say THE conference. I know most of you don’t get to go to conferences. Or have nice computers. Or use foreign keys. Or have nice things. BUT. One thing you do get to have today, is the same popular Oracle SQL Developer features demonstrated to you, …
Updated SQLcl: nicer inline editing and column completion
We updated the Early Adopter offering of SQLcl today. Go get it. But first, I’m assuming you’ve heard of SQLcl? If not – Read the slidedeck, watch the movie. We’ve put in a ton of enhancements and even more bug fixes. And Kris showed off a new feature today that mimic’s our SQL Developer grid preference for displaying NULL ‘values’… …
Oracle SQL Developer version 4.1 is Now Available
Oracle SQL Developer version 4.1 is now available. So is SQL Developer Database Modeler version 4.1. And so is Oracle REST Data Services version 3.0. Java Requirements For SQL Developer Java 8 is now supported. It’s also required. If you need to, you can install Java 8 without removing Java 7 and ‘breaking’ your other Java applications. You can even …
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 other table Confirm your …
- Page 1 of 2
- 1
- 2