User Tools

Site Tools


This is an old revision of the document!

select 1 from dual where regexp_like('A-   - 1234', '^A(-| ){0,}[[:digit:]]{4}$')

select regexp_instr('A-   - 1234', '^A(-| ){0,1}[[:digit:]]{4}$') from dual

select regexp_substr('am parkweg 27, A-1234, Stadtdorf', 
                     'A(-| ){0,1}[[:digit:]]{4}') as plz from dual

select regexp_instr('Mark Hofstetter', ' ') from dual

select 1 from dual where 'Mark' like '%M%';

select regexp_replace('Blastr. 27', '[[:blank:]]+', ' ') from dual;

select regexp_replace(regexp_replace('Bla   Str.      27', '(str).',  '\1asse',1,1,'i'), '[[:blank:]]+', '_') from dual;

regexp_like(PLZ, '^A(-| ){0,}[[:digit:]]{4}$') or regexp_like(PLZ, '^D(-| ){0,}[[:digit:]]{5}$')
kurs/regular_expression.1410376975.txt.gz · Last modified: 2017/03/21 10:02 (external edit)