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.