I said there were 8 ways to avoid using SELECT * FROM queries in SQL Developer – but I didn’t actually count them. So let’s do that now. @MarkusHohloch @tobias_arnhold there's about 8 ways to get columns to your query— OracleSQLDeveloper (@OracleSQLDev) November 23, 2016 But wait, what’s wrong with SELECT * FROM queries? you don’t need all the columns columns can change columns can be added columns can be removed At some point, your…
We by default don’t store certain things in your SQLcl HISTORY list – like CONNECTs. For obvious reasons, it’s best not to store certain things, either for convenience or for security. Here’s how that is controlled. SET HISTORY BLACKLIST command1, command2, …, commandN An example: So I previously added ALTER to the list, and just now added DESC. And then I ran a few commands that use those blacklisted commands. Now let’s check our HISTORY.…
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…
One of the coolest features of Oracle REST Data Services v3.0 and higher, is the ability to REST enable your Oracle tables and views. You get a full REST api on your table – INSERT, UPDATE, DELETE, Select with or without predicates and sorting, and getting metadata. You can also batch load records. I’ve talked about the SELECT and GET bits before. What I’m going to show today is how to POST (INSERT) up a…
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.
When using the data modeler, we assume when you add a foreign key, you haven’t already created the ID column. So we create that for you. Here’s what that looks like. I draw the relationship. I don’t want that. I want it to use USER.USER_ID instead. Click on the Column, and toggle it to USER_ID. When I click ‘Apply’ or ‘OK’ – the generated column goes away. If you don’t like being asked, you can…
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…
We introduced the Instance Viewer in v4.1. We show you in real time what’s happening in your database. To get there, open your DBA panel. Connect. Then go to the Database Status node. Storage bits are interesting, but maybe you’re more excited about the specific workload. So in version 4.2, we’ve added a Top SQL panel to the screen. It auto-refreshes every few seconds, and you can sort it by several different performance metrics. If…
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…
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 forget about the HotSpot feature we added in v4.1.