And that is just one more reason you should NOT USE Oracle.
Postgres is light-years ahead! Trust me!
Yes, we will still using Oracle for many decades... but as a legacy. There are people whom still have to do stuff in Informix (arghhhh!), and Oracle is walking the very same path. They refuse to implement useful things, just because "is hard".
Seriously! I'm no seeing a single new project that uses Oracle as db. Why on earth someone will choose an expensive/useless Oracle database in 2022, if we could use a free/useful Postgres one?
R.I.P. Oracle.
Thanks for all your services. You were the best in 2000's... and there you have decided to stay: 20 years in the past.