🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

I have stumbled across some implicit data conversions that I was unaware of, causing poor performance when querying JSON-relational duality views. I demonstrate what I mean using a simplified example in this blog post. salvis.com/blog/2025/01/2…

Erste ora2know-Veranstaltung bei Ordix in Köln. Intro und Termine:

The effectiveness of JSON-Relational Duality Views in ORDS - GET PUT POST DELETE your Oracle Database CRUD AutoREST is demonstrated by Tim Hall ∞🐵+∞⌨️ Tim Hall for #OracleDB23ai. oracle-base.com/articles/misc/… Many thanks!

Communicating with autism can create subtle challenges. Here's a good example of some of the nuances in just a single sentence - nuances that are often lost on someone with ASD.

Use dot-notation to access attributes of stored #JSON with Oracle #SQL SELECT tab.jcol.attr This returns a JSON data type => implicit conversions & poor plans Use type methods to set the type: SELECT tab.jcol.attr.number() Philipp Salvisberg demos salvis.com/blog/2025/01/2…

Speaking this Thursday DeveloperWeek on JSON, Relational and if those two like each other or not ;-) developerweek.com

Attending DeveloperWeek and learning about JSON and relational databases from Beda Hammerschmidt!

"Man lernt an einem Tag mehr als in vielen Wochen des Selbststudiums" – 🎤 Interview mit Martin Bach, #Oracle Produktmanager für Multilingual Engine (MLE) und Keynote Speaker der #apexconn25 im Europa-Park in Rust ➡️ scomp.ly/Z45zNnn #orclapex #PLSQL #JavaScript #LowCode

Mail in ballot for German election arrived today. Now i can vote. And then go and find a time machine - election closed yesterday #wahlunterlagen

The new #FJSON feature in #OracleForms simplifies the creation of comprehensive semantic JSON content, which can also be transmitted via WebSockets to HTML or other desktop applications.

Community feedback is invaluable. Some time ago you asked for clarification concerning the TYPE clause in json_table(). As it turned out, the documentation could have been clearer. Earlier today I saw that the relevant section has been updated and refreshed.

DBMS_DEVELOPER Package - Database Object Metadata in JSON Format oracle-base.com/articles/23/db… Oracle Database #23ai

Previously on thatJeffSmith: JSON_OBJECT_T and ORDS: what’s the ‘best way?’ thatjeffsmith.com/archive/2022/0…

Learned something new today: JSON Relational Duality Views allow you to mark columns as "Flex" columns. Those must be defined as `JSON (OBJECT)`, or else an error is thrown. More details about the column modifier can be found in the SQL Language Reference docs.oracle.com/en/database/or…

Are you looking to move data from a document database such as MongoDB to a relational database, but you are unfamiliar with relational concepts? If “Yes”, then check this new blog post about the JSON-to-Duality Migrator: blogs.oracle.com/database/post/…

Join as tomorrow May 13th at 5pm CET (9am CT) for the AskTom JSON session (only new slides and lots of LIVE demos): asktom.oracle.com/ords/r/tech/ca… Beda Hammerschmidt Hermann Bär

Are you a MongoDB developer? #OracleDatabase has full compatibility with MongoDB so you can run your apps without any changes and gain performance, availability, disaster recovery, and more. Get started at social.ora.cl/6018Nj7pr theCUBEresearch

Are you a MongoDB developer? #OracleDatabase has full compatibility with MongoDB so you can run your apps without any changes and gain performance, availability, disaster recovery, and more. Get started at social.ora.cl/6011Nj7Rl TheCUBE Research