Why won’t the code helpers in Oracle SQL Developer work with my SQL or PL/SQL?
Bookmarks in your SQL Worksheet
How to navigate your SQL Worksheet in Oracle SQL Developer using numbered bookmarks.
Oracle SQL Developer version 18.4 is Now Available
Oracle SQL Developer version 18.4 is now available!
Your Favorite Posts from 2018
Your favorite Oracle SQL Developer posts from 2018.
All of the Tuning Features in SQL Developer (2018)
Slideshare won’t let you update slide decks anymore, so I just uploaded my latest version as a new offering. All of the Performance Tuning Features in Oracle SQL Developer, 2018 Edition from Jeff Smith I’ll be presenting this topic at UKOUG this week. if you’d like me to present this to your group of the developers and administrators, drop me …
Scheduling Exports of Your Data Using the Cart
This post won’t show you how to acutally do the scheduling bits – I’m going to assume you know how to use contrab or Windows Scheduler -but I will show you how to get SQL Developer setup so that you can call it from the command-line to do your export. Our requirements – from an AskTom question – I want …
Oracle SQL Developer Version 18.4 Sneak Peek
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 [email protected] @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6 — Tobias Arnhold (@tobias_arnhold) November 15, 2018 The short answer is, that …
Video: What’s New in Oracle SQL Developer for 2018
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 …
All of Your Objects: Reports
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 …
Modeling JSON in Oracle Database Tables, Part 2
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 …