Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check for greek characters in a string

apollon27Jan 21 2018 — edited Jan 21 2018

Hello I have the following requirement, I open a file browser using webutil. in oracle forms

if the filename contains Greek characters then I must say to the user that this is not acceptable.

Generally I have a string and I want something I suppose like a function, to check if the string contains greek characters.

I think of the following code.

IF INSTR (p_filename , 'α' ) > 0 THEN

return -1

ELSIF  INSTR (p_filename , 'β' ) > 0 THEN

return -1

ELSIF  INSTR (p_filename , 'γ' ) > 0 THEN

return -1

..........

I would like to ask if there is a better solution.

Thank you.

This post has been answered by Frank Kulash on Jan 21 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2018
Added on Jan 21 2018
4 comments
848 views