An example? A full credit card processor in stored procs. I really mean full, it handled the call outs to financial providers, managed the 2-phase commit, replied to the app, all within a single call (Stripe API is the closest I've seen to this in the 30 years since).
It remains possible to do things that are crazy and powerful, very quickly.
Whether the people here would want to is a different question. But if you are in a large corp and Oracle is available it is easy to do crazy things.
Once these things are done, Oracle is going nowhere. They are now in your system for the life of your product.