You might have heard we now have a new SQL Developer in the family: SQL Developer Web. If that’s news to you, here’s a quick video recap: Hopefully you noticed that one of the main features of SQL Developer Web (and SQL Developer Desktop!) is data modeling. We were thinking: wouldn’t it be nice if could pull up a diagram you built in SQL Developer Web into the Desktop copy of SQL Developer or SQL…

This past week we were at KScope – the premier all things Oracle conference here in the United States. The Database team were very well represented, and we did 15 minute lighting talks. Maria has already shared her slides/talks here – they were AWESOME! Here are mine. Let’s Go Shopping It’s all about the Cart. Oracle SQL Developer: The Cart from Jeff Smith Social Media – Why a Database Person Should Care Plus 3 quick…

We have a LOT of application preferences. And users have a funny habit of asking us to add MORE to every release. So, it’s great that we make it very easy to customize their SQL Developer experience via a few clicks and toggles. But, it’s kind of hard to find the RIGHT switch when you want to go change something. Well, a few releases ago – Bad Jeff for not talking about this sooner!! -…

You can download it here. With this VirtualBox Appliance, you can spin up a virtual machine that already has Oracle Database, Application Express, REST Data Services, SQL Developer, SQLcl, and more…all running for you, automatically. The APEX team has also given you a TON of new APEX 18.1 focused labs. Including one for using REST Enabled SQL from ORDS. How to launch SQL Developer In the terminal/console, run ‘sqldeveloper’ That’ll launch 18.1 for you. Create…

As a feature: Been there forever On the desktop by default 80% of you aren’t using it I think it’s a feature that can really turbo charge your experience with the database and SQL Developer – so I did a 10 minute talk on the subject. So if you’re curious about what you might be missing, here you go! And for folks that would like the slides: Oracle SQL Developer Reports from Jeff Smith

This year the KScope conference is in sunny Orlando, Florida. Do you live in the area? Do you work with Oracle technology? Then I’d like to invite you to come hang out with us for a very special week. On Sunday, we have 6 dedicated hours to talk about all things Oracle Database, in a series of lightning talks. In 15 minutes or less, we are tasked to entertain and educate you on various Oracle…

In two previous posts, I have: Introduced Oracle SQL Developer Web and did a quick demo of the Worksheet Demonstrated the data modeler diagramming feature. Today, I want to show you our CREATE and EDIT TABLE dialogs. While I aim for 10 minute videos, I had to go into overtime, and came out at 13 minutes. But as a bonus, you get to see me think in real time as I cocktail-napkin-style ‘design’ my table.…

Not able to make my Tips & Tricks talk at the Great Lakes Oracle User Group conference this week? Don’t have the 50 minutes to watch my recorded YouTube version? Can you spare 90 seconds? You don’t even need to turn the sound on. Just watch this GIF. To recap: ALT+G to do a search Use Doc Tab Groups to see multiple things at once Ctrl+Space to auto-complete Filter grids with WHERE clause predicates drag…

In this 10 minute video, you get: super quick recap of the Worksheet building a new diagram moving stuff around, changing the colors generating DDL generating a data dictionary report saving and searching diagrams This was my 50th post on YouTube. If you like what you see, be sure to subscribe there so you don’t miss any updates. Your subscriptions will also prove to my kids that I AM A REAL YOUTUBER. Well, probably not.…

We are now live in the Oracle Cloud with Oracle SQL Developer Web. Wait, what’s SQL Developer Web? It’s a browser based version of Oracle SQL Developer powered by Oracle REST Data Services. If you are a Database Cloud Service customer in the Oracle Cloud, it’s rolling out now to those subscribers. If you’d like to know more and see a quick demo, I made you a video 🙂

Someone asked, hey, I know how to hide the schema notation in our diagrams You can too – READ THIS POST – …but (there is always a BUT), how can we hide it from the data dictionary reports as well? The answer is – you need to manage the report template. When you open the Report dialog, switch to the Custom Templates. We give you two custom templates to play with, ‘Table_one_level_list_Props’ and ‘Tables_2_Levels’. Pick…

A question from the innerwebs – Hello, please, is it possible to define and save a (sub)set of objects for comparison? In Databasediff wizard we have an option to define objects, but it’s a bit cumbersome to do the same thing over and over again, so it would be highly useful to save options and selected items for comparison for future use. Thanks a lot, The answer is, Yes! We have a nice Oracle By…

We’ve gone a bit manic when it comes to releasing updates for SQL Developer:- 4x a year, or once a quarter. We’re committed to delivering on this schedule, but we reserve the right to skip a release if there’s no urgent need. More frequent releases means not as much time to wait for bug fixes, and also that new features will be rolled out in smaller changes vs more dramatic ones. Here’s where we’ve been:…

Normally when someone asks me about ordering packages, I check the doorstop for our daily Amazon delivery. Ok, it just seems that way, and I’m lucky that my awesome wife/partner doesn’t read this blog… …but what we’re really here to talk about is finding stuff in your PL/SQL package. I think there are 2 types of folks: Those that code willy-nilly: they build out each variable, procedure, type, function as it pops into their mind…

This blog post was going to be JUST that picture above. The size of the logos show what I think are the importance, reach, or quality of their content. But I figured I should throw some words and numbers to go with it. You might now know this, but I’m a bit obsessed with Social Media. It’s worked for me, and I think it can work for you too. But where to spend your time?…