In honor of today’s holiday, a hat tip to our Irish friends! Spot the places I’ve configured SQL Developer to show green I can spot 7 different spots in the above screenshot where I have configured SQL Developer or manipulated the output to show the color green.
You may wish to store your PL/SQL code in files with file extensions other than our defaults. We ship with .klr, .pkb, .pkh, .pks, .plb, .pls as associated file types for our PL/SQL editor and for opening said files on your machine with SQL Developer. But maybe at XYZ Incorporated, you keep your package bodies in files of type .bdy Are you stuck using our SQL Worksheet for doing serious PL/SQL work? No! Just setup…
Our team pushed a TON of updates – fixes and new features – this afternoon. SQL Developer 4.1 EA2 SQL Developer Data Modeler 4.1 EA2 Oracle REST Data Services EA2 SQLcl updated 3/9/2015 (it’s listed after the SQL Developer downloads) What time is it? I have much, much, much more to say on these products and updates. But for now, go download, and provide feedback to the Community forums. Java 8 SQL Developer 4.1 has…
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 a test 🙂 If I find this portable, we can add it other, more official places.
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 I said ‘explain plan’ too many times in the session…EXECUTION Plans can be quite big. And the problematic bits generally…
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 we also have gauges, and I’ve talked about them before. But what about dials? So we can graph numbers, but…
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!) the Development Tools Team will be hosting a weekly webcast. We will show you things that we think you might…
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 tweet/blog post from Oracle ACED Scott Spendolini of Oracle APEX fame… Screaming at Each Other http://t.co/Dqsw4xwYmR #orclapex— Scott Spendolini…
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 things that I see people doing ‘the hard way.’ After just a few minutes or reading (ha ha, more like…
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 that does have some live demo if you prefer to watch instead of read. Let us know if you have…