There are still tons of PL/SQL developers, and a huge ecosystem that uses these things. Triggers were big at one time too.

You will be surprised how H1B 'specialised talent' developers are just people who have worked on these ancient technologies all life, are near impossible to replace so you are left with no options but to hire them.

Oracle is a whole different specialisation in itself and its tentacles go very deep and afar.