Why does ORACLE SQL Developer accept square brackets as regular characters?

Question

Oracle

Program ORACLE SQL Developer Version 4.1.1.19 Build MAIN-19.59
There is a line on the command line:
select count(*) from PAYLOAD7 where CODE_PRD LIKE '____.[1-9]';
But ORACLE SQL considers the combination "[1-9]" not as a range of numbers, but as ordinary characters and selects the format strings: "GHTY.[1-9]", and GHTY.9 is required.
What's wrong? How to escape square brackets?

Answer 1

regexp_like