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
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…
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…
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…
Due to popular demand, we’ve added this new preference to the formatter. With it turned on: On 851303639697f099283009_000000 Off 851303639697f099283009_000001 As always, send us your feedback! Example code always helps us make improvements.
A small feature that could have a huge impact on your code – we try to make sure you know your PL/SQL might be vulnerable. SQL Injection is a very well known security risk in the database world. Nefarious people could ‘inject’ SQL into the code you’re about to execute via some some of user input you make available to them. We even talk about this in the Oracle Database Docs and provide some examples…