Customer asks: We tried also to apply some naming conventions but I think we didn’t understand something…. Having a logical model with a table having the column X, and a glossary having the standard name as Y. Can I apply some checks based on the glossary directly in the logical or relational model? Yes, in fact you can. Basically how it will work is: You will define a glossary, having words you approve for your…
Having an extra bit bucket in your tables is pretty easy now in Oracle Database 12c and higher. We offer native JSON support [JSON DOCS] – you can have a free form text column and store anything you want in it. AND, we pretty much give you the full power of the SQL interface to those bit bucket items – pretty neat I think. I’m still big fan of the relational paradigm, and I think…
Here’s a 15 minute video showing you everything you need to know about using the data grids in Oracle SQL Developer. Basically: settings fonts and look & feel column sizing column(s) sorts client side filtering copy & paste tricks single record view complex data type support – Spatial & BLOBs dates & timestamps inserting multiple rows via PASTE I do NOT talk about the EXPORT feature – because then it would be a 30 minute…
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…
We released a new version of ORDS this week, and I blogged about a new feature in that release – Auto PLSQL. In that post, I briefly mentioned packages, but I wanted to take a quick moment to show that ‘live.’ So assuming you have HR installed somewhere and HR is REST enabled, let’s build this package. 129526083067266f3c0a1b3_000002 And let’s REST enable it…here’s the code, but of course we could also use SQL Developer’s context…
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…
I wrote this on LinkedIn, but that platform doesn’t play nice with Flipboard, and not all of you are connected with me there. So, if you Twitter, take a second and follow these people. You can thank me later. If you’re looking to follow even MORE people, go read that story, and you’ll see how to fine 194 more.
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…
It’s Friday! Let’s be honest though – you’ve not accomplished much this week. Monday was a holiday, emails have stacked up, lots of your co-workers are on vacation. So how can we rescue this losing scenario and turn it into a major victory? This trick will save you so much time, you’ll be mad I didn’t make you learn it earlier. Apply a Filter to Your SQL History Next week we’re going to work on…
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…