Obsessed with Oracle PL/SQL

From what I can tell, JavaScript developers write much more complicated code, to handle much more challenging requirements, than I do, with my SQL and PL/SQL programming in the Oracle Database. I am quite certain that JavaScript developers feel this sentiment even more strongly. People like me (veterans of multiple decades of database-centric application development) are seen as dinosaurs, using ancient, uncool technologies. The things we do seem distant, unimportant, even simplistic, compared to the tough stuff they deal with on a daily basis: asynchronous! streams! containers! microservices! promises!....and so forth. Heck, I haven't even had to change my "framework" for years and years! :-) But here's something we should all of us keep in mind: Sometimes relatively simple tasks can also be  critical tasks,   in which case simplicity becomes a significant advantage (a feature, not a bug). Now, don't get me wrong. I am not saying that I think the ta...

I am (finally) diving in to explore and then write about using JSON in Oracle Database 12c - with SQL (Releases 1 and 2) and - more to the point for me - with PL/SQL (based on enhancements in Release 2). Expect to see posts on this blog, articles in Oracle Magazine , quizzes and workouts at the Oracle Dev Gym , and more, in 2018. To that end, I have been collecting links to useful resources on this topic, and I realized that you might benefit from that list just as much as I will. So why not share it now? :-) Before exploring Oracle-specific resources, visit json.org to learn more about JSON itself. Oracle Documentation Let's start with the official source of truth: our doc set. First and foremost, we have the  Database JSON Developer's Guide , which covers how to store, generate, view, manipulate, manage, search, and query JSON. And here are some specific links you might find handy: Basic SQL/JSON Path Expression Syntax The basic syntax of a SQL/JSON p...