-
Finally, ODT shows some love for case
ODT – Oracle Developer Tools for VS Code – is not getting enough love online. It has become a wonderful tool. For me it is starting to replace SQL Developer in part of my workflow, especially adhoc queries and file-based work. What had me not using it for a long time was that it defaulted…
-
Dumb Oracle refuses to use my great index
Let me tell you a story about a developer, let’s call her Sue, that had proved that Oracle was having mood swings and just didn’t use a perfectly good index even though it was the perfect index to use. This of course made Sue very upset and she spared nobody from her bitter words about…
-
Grabbing sql_id for the SQL
I read Daniel’s recent blog about five ways to grab the sql_id and remembered reading Connor’s about getting it before you run a SQL. At the time it hit me that one ought to be able to use this to simplify the workflow. Often we run a SQL and then use some marker – typically…