You want to write a query. You want to use a subquery in that query. You don’t want to type so much. What to do? Enter the Query Builder. It’s been part of your worksheet for years. Click on it. Drag a table into it. But I don’t want to see the department_id in the output of my query, so uncheck it in the ‘Output’ column down below. Now right click in its corresponding Criteria…
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 you how to view multiple files/objects/documents/windows at once. So, you can use this trick to…
So version v4.2 has been out for Early Adopter testing and feedback since September. We’re still doing work on those new features and improvments, and will also be adding additional features and tweaks in a 2nd Early Adopter update, stay tuned. We’re of course also fixing bugs! You still have time to make a positive impact on v4.2 – so please share your 2 or even 3 cents. Based on feedback, some tweaks to look…
How to create ORDS users for basic auth on your Oracle Database REST APIs. You’ll supply the name of the user, its roles, and a password.
I often spend a lot of time on the ‘cool’ and ‘advanced’ tips and tricks when doing talks for SQL Developer. Today, I’m co-presenting with Helen , and she chose to spotlight a bunch of stuff around filtering. Follow @HelenJSanders I love the topic, but I usually short change the subject in my talks. Today, let’s review all (most??) of the ways SQL Developer can help you get past the clutter. Connections You can hide…
There are tons of properties you can set in your design objects. In fact, I discovered a ‘new’ one this week thanks to my friend David. #Oracle #SQLDev Data Modeler users please up vote my feature request to allow additional “display as” componentshttps://t.co/2fIbVXmIn9:::— david schleis (@dschleis) October 12, 2016 Display as…what’s he talking about? Oh, this. But what if the set of values we give you for a table or column property aren’t enough? What…
Twitter wasn’t playing nice, so I’ll just blog this 🙂 Want to extend your history size from 100 statements/scripts? Add this to your login.sql. 5433239896af0292eaf114_000002 Don’t go crazy, remember each item gets written to its own XML file. We load those on start-up.
I love SQLcl – I use it more and more every day. But. Sometimes I need a GUI. Copying and pasting code between the two can be cumbersome – Toggle the Block Cursor You can do this in v4.1 with the mouse and clicking to set the cursor points. In v4.2 you can do it by toggling the block cursor mode, and then it’s all keyboard from there. I have a standing ER to be…
I’ve talked about keyboard shortcuts before… But What About Going From One Data Grid to the Next? Apparently I neglected to show that one. Move Right: ALT+SHIFT+F5 Move Left: SHIFT+F5 Just so you know I’m not making this up..
The old formatter, the code that’s used to format your code from v1 to version 4.1 was based on some pattern matching code and expressions. It was very limited, and didn’t like a lot of syntax and coding styles common in Oracle code. It also wasn’t very flexible. So we built a new engine. One that takes advantage of our Oracle parser. The new formatter (the part you can see like the preferences) looks very…