We tried 15 minute talks at a conference last week, and I think they came out OK. I figured for the folks who weren’t able to come out to the conference, maybe you’d like to see the talk? So here it is. The basic gist of the talk: SQL Dev is a BIG, DEEP tool You don’t have time to figure out all the ‘cool’ stuff I DO have the time Here’s the cool stuff…
Missed out on KScope17 this week, or were there, but missed out on my talks? Have no fear – you can now catch up on the 3 Oracle SQL Developer features that you should be using, but probably aren’t. I tried my best not to get preachy in this talk, but I must admit it’s still a bit preachy. Oracle SQL Developer: 3 Features You're Not Using But Should Be from Jeff Smith Polling the…
New Oracle REST Data Services (ORDS) drop today. Per usual, mostly bug fixes And per usual, sometimes we like to sneak in new features as well, and this release is no different. You can now have ORDS automatically create POST handlers for executing your PL/SQL. This is a LOW CODE solution. You could of course ALWAYS roll your own RESTful Service to run your PLSQL, and in many cases, you’ll continue to want to do…
A quick demonstration for configuring Oracle REST Data Service’s embedded Jetty web server – adding access logs for ORDS, with just a single XML file.
Updated 26 April 2022 ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one. Need help with “The pool named: |default | is invalid and will be ignored” ?Try this post, Troubleshooting ORDS startup errors, the pool is invalid When you publish a RESTful Service under HR on database X, ORDS resolves the call to the proper jdbc connection pool, then proxy connects from ORDS_PUBLIC_USER…
SQL Developer has averaged about a single major release a year. We’ve also always had an Early Adopter or open beta where we would debut new features, and you could provide feedback. I think this worked – quite well even. But that’s over. Starting later this year, you’ll see us put our product (SQLDev, Data Modeler, SQLcl, ORDS) release updates every quarter. This allows us to keep up with the frequent release cycles we see…
Someone asked, I have this cool report, how do I get the chart out of it? For now I’ve been taking screenshots. So let’s look at how you can get your Report out to HTML (and a PNG.) When I say HTML, I mean you have a SQL Dev report that’s generated by SQL Developer itself. I am NOT talking about DBMS_OUTPUT reports that you can use to physically print HTML3 code and have it…
Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on the main File menu. First, we don’t want the main diagram in the report, that’ll give us EVERYTHING. I just want the subview diagram. So after un-checking ‘include main diagram,’…
Generating Links with Oracle REST Data Services with both SQL (GET) and PL/SQL (POST) examples.
You can’t REST if you don’t HATEOAS, so you need to know how to generate hyperlinks in your JSON responses for your REST APIs.
“I do not want a line break after the and statement.” I’ve seen this come up a few times, so let’s answer that right now. 7163301226a1a40b9c4363_000005 Default formatting changes that to 7163301226a1a40b9c4363_000006 This is NOT what the person asking for help wants. To the Preferences! So let’s change that and see what happens. Or… Speaking of OR