Home > Software engineering >  Oracle Regex: Accept all kind of values from Varchar2
Oracle Regex: Accept all kind of values from Varchar2

Time:09-22

in Oracle Pl/SQL, what does this expression mean?

WHERE REGEXP_LIKE (FIRSTNAME,'^[A-Za-z ,] $');

And how can I change to permit any kind of Varchar2 values?

Thanks a lot in advance.

Luis

CodePudding user response:

It means that first name can have only lower and uppercase letters and a comma.

If you want to accept any character, remove the whole WHERE clause.

  • Related