I work with banks, insurance companies, telecoms, manufacturers and ocassionally retailers in Europe, they all use Oracle for well over half of their applications.
They are doing something wrong. Say what you want about their commercial strategy, the product itself is pretty good. It can definitely do pagination, and I hope they are not doing skip and limit.
It hasn't been popular? I guess you mean "cool" or "trendy" but well more than half of enterprise applications work on oracle, closer to 75% in fact.
Yes, plenty of companies are exiting oracle but it will still dominate for at least a decade. Sometimes there's just no good equivalent, and no, Postgres cannot compare even tho it's a great DB for many use cases.
Give it a honest shot, learn the limits, help your team establishing best practices. Depending on the language, framework and vertical it can be mor e or less autonomous.
It always needs good specs, clear steps, and lots of testing. Some of which can be automated by the AI itself. Make sure you write yourself or strictly review (am besten im vieraugenprinzip) the code that touches anything related to money or safety.
I work with banks, insurance companies, telecoms, manufacturers and ocassionally retailers in Europe, they all use Oracle for well over half of their applications.