Differences

This shows you the differences between two versions of the page.

--- kurs:regular_expression [2008/10/23 12:25]
127.0.0.1 external edit
+++ kurs:regular_expression [2014/09/10 21:22]
127.0.0.1 external edit
@@ Line 1: / Line 1: @@
+<code>
+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}$')
+</code>

dokuwiki