Skip to content

Instantly share code, notes, and snippets.

@YasuakiHirano

YasuakiHirano/exp_kana.sql

Created January 21, 2016 05:25
Show Gist options
  • Save YasuakiHirano/69062c7c16f88b783e77 to your computer and use it in GitHub Desktop.
Save YasuakiHirano/69062c7c16f88b783e77 to your computer and use it in GitHub Desktop.
Download ZIP
oracle hankaku kana check
Raw
exp_kana.sql
SET SERVEROUTPUT ON
DECLARE
vstr varchar2(256):= 'ﾋﾗﾉ';
BEGIN
IF (REGEXP_LIKE(vstr, '^([ｦ-ﾟ]|[0-9A-Za-z])*$')) THEN
dbms_output.put_line('OK');
ELSE
dbms_output.put_line('NG');
END IF;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment