The 2018 conference season is winding down. Next week is DOAG in Germany – an amazing conference by the way – and a short time after that is the UKOUG Tech 2018 conference in Liverpool, England. This will be my second experience presenting at UKOUG, and I’m looking forward to reconnecting with old friends and meeting new folks – all while talking about ORDS and SQL Developer. The Tuning in SQL Developer talk is a…
So someone asked us on Twitter this morning about a new Document that opens on an Export of a query result set. How can I prevent the "Export Tool" log in SQL Developer 18.3?I get it whenever I create some DDL over the navigation menu.@oraesque @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6— Tobias Arnhold (@tobias_arnhold) November 15, 2018 The short answer is, that wasn’t intentional – it’s a BUG. Good news – we HAVE cleaned that up for version…
One of the improvements for version 18.3 was a much improved, performant query builder. Of course, not all things are free. Or in fact, nothing is free. So who paid for these performance gains? We disabled one of its primary features. But first, let’s take a step a back and explain the scenario. How it Was, Pre 18.3 The query builder would allow you to reverse engineer a query in a worksheet to a visual…
This was one of my 3 sessions at Open World last week. None of them were recorded, but I figured you might find this one interesting, so I ran through the slides again here. If you search this blog for things like ‘18.1’, ‘18.2’, and ‘18.3’, you can find all the blog posts I put together showing some of these features. But a short list would definitely include: SQL Injection Detection Faster Query Builder &…
Today’s question: I am looking for a way to list out all and count all objects by all schema, any idea? So the connection tree is nice in that it makes it easy to see specific types of objects by schema – but if you want a FLAT view of a schema, it’s not so great. Ok, so what’s a SQL Developer user to do? Try our Data Dictionary Reports The Reports panel is there,…
In case you haven’t figured this out by now, 90% of my material here is generated by questions from folks like you out there. So thanks for the never ending supply of content! And it gives me an opportunity to keep learning as well! So the question: I believe this json data type in MySQL would probably map to either CLOB or VARCHAR2 in Oracle. Is this something which can be achieved by defining custom…
Was helping someone on Stackoverflow this morning, and thought you might enjoy seeing this process as well. PROBLEM: You’ve created a schema script, you’ve generated the DDL, and you ran it on your brand-spankin’ new database. Except. Except, you ran that script as SYS, and your schema scripts didn’t have a SCHEMA defined. So you’ve corrupted your SYS schema!!! How to fix that (FLASHBACK!) is a different post. This post is about how to assign…
Things to know: MANY bug fixes The Windows Embedded JDK is now Version 8 update 181 You can have nested connection folders in the main and DBA connection panels Real Time SQL Monitoring reports can be exported to (non-flash) HTML Connections Some of you out there work with MANY databases, and so of course have tons of connections to work with in SQL Developer. Now you can have as many levels of folders as you…
The forwarding bit isn’t a new feature, but we have introduced new ORDS response header variables in version 18.3 of ORDS.You can now also read in the body of your request as a CLOB vs a BLOB. This post shows how to take advantage of both features. The only thing ‘new’ here is the name of this ORDS parameter. From the early days of the Oracle Application Express Listener, we always had X-APEX-STATUS-CODE and X-APEX-FORWARD.…
It’s easier to run things unsecured. It’s unconscionable to run things unsecured. DON’T BE THIS GUY. So Let’s Secure My Database and my Web Services So I have a collection of REST enabled objects (tables, view, and procedures) and a SLEW of RESTful Service modules. I want ALL of them locked down. So I need to create a Role and Privilege. And then I need to assign that privilege to what I want protected. Without…