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…
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…
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…
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…
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…
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. 60174789067261beb26f2d_000002 Don’t go crazy, remember each item gets written to its own XML file. We load those on start-up.
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.
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..
Someone said we should make the view source searchable, and that we should show any errors on a view. Actually, it might have been a few dozen of you. A reader reminded me that we actually implemented this in v4.2. Code Outline I’ll go into more depth here next week when I’m back from Open World, but we’re working on building a new advanced Code Outline. Right click in your editor to open it. It’s…
In both v4.1.5 and v4.2, you can now select objects from your database tree, and drag them to another connection to have them copied. The source can be: a MySQL, DB2, SQL Server, Sybase, Terradata, or other 3rd party supported RDBMS an Oracle Database The destination can be: an on-premise Oracle Databaes an Oracle Database running in the Oracle Cloud You have a few options: For tables, we’ll also grab it’s indexes, triggers, and constraints.…
