They’re just going through their final shake-downs and certifications. Versions 23.1 of those should be out next week. Nope! I’ll have much more to show/demo in a week or three, stay tuned! What about SQL Developer, Data Modeler, and SQLcl? Reminds me I need to update my ‘ how to export ORDS REST APIs‘ blog post… Is that all? Now, my export script is big…too big for all of it to be shown in the slider that pops out when clicking the Export button, so I’ll need to use the ‘Download’ button vs simply copying the PL/SQL to my clipboard. Instead of simply exporting 1 module at a time, I can export…all of them! Click the button to get all 63 Modules in one go. REST Workshop Export SchemaĮxactly what it sounds like. Note if you’re in that small case of ORDS deployments with multiple pools, you’ll need to use the advanced panel to set the pool mapping as desired for your new session. Keep your passwords/credentials, securely folks.Īnd finally, when you sign out, it immediately takes you back to the sign-in page. We automatically support your browser stored credentials/auto-fill.Ĭhrome goes, oh I know this – if I select one of those, it will pre-fill the form AND submit it, so it’s actually a single-click operation. Which logs me in, and I see this – Ta-da! Even more Connections improvements And later this year we hope to have it so that ORDS can automatically ‘sort’ aliased schemas automatically, so it should get even easier.īut let’s login with that exact scenario – pool mapping pattern / rest enabled schema alias Note that this isn’t a common deployment for customers, so this wouldn’t be required except in ‘Advanced’ situations. I would in the advanced panel, supply the ORDS mapping pattern to my pool, that would be ‘orcl’, then I would supply the alias for JEFE, which would be ‘boss’, and separate the two with a ‘/’ Let’s say I have two pools, with a pool mapped to a database called ‘orcl.’ And in that database, I have a schema called JEFE, REST Enabled as ‘boss.’ Then you’ll use the Advanced panel to sort that. multiple pools configured in your ORDS server.What if you don’t have a ‘simple’ scenario?Įxamples of something not simple, combinatations of: Simply put in database username and password. What used to be two-step series of prompts and dialogs, is now a single dialog. Most of the time you’ll see this are for authenticating to SQL Developer Web. Inspired by this blog post from our friend and co-worker Carsten, and developed alongside the APEX team □ Simplified/Nicer Looking Sign-Ins When we’re done, you’ll should see a confirmation of version – Success!Īnd now starting it back up with ‘serve’ – ords –config /path/to/config serve So what’s new? Oh that sounds interesting… APEX Management endpoints in the Database API Lot’s of new goodies here. Run the ‘install’ command, and run through your pools as desired, then start ORDS back up. Then use set operations to see if all the attributes and values match.It’s that time of year again, our 2023 quarter 1 family of products are starting to trickle out, with ORDS 23.1 available today ( Downloads Page.) Just under the deadline □ Upgrading, same as before SELF JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN 167 4,360 7.5 years ago Mike Hichwa (Oracle) Script Car Database Database to perform Advanced DML, PL/SQL, Triggers, Procedure and Functions 72 4,218 5. So to see if two documents are the same, you had to first convert them to traditional rows-and-columns. SQL Join query examples, used to select rows from multiple tables using a join key. Next Steps READ more about Oracle Database support for JSON (documentation). You need to ignore whitespace and attribute order when comparing JSON documents. Once you are able to correlate PL/SQL arrays with JSON arrays (correcting for differences in indexing, for example), you will find it easy to productively write code to work with JSON arrays in your PL/SQL code.
0 Comments
Leave a Reply. |