var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Need some help on using SUBSTR/INSTR.
I need to pick out the first 6 characters after the occurrence of the first space character in the following string: i.e., FGH111
If anyone could spare a few minutes?
ABCDE FGH111/QWE9999UCQWE:LABEL=QWERTY, CELLID-12345
Last edited by shajju; 02-05-13 at 07:46.
You do not need a parachute to skydive. You only need a parachute to skydive twice.
Regular expressions option:
SQL> with test as
2 (select 'ABCDE FGH111/QWE9999UCQWE:LABEL=QWERTY, CELLID-12345' col from dual)
3 select regexp_substr(col, '\w+', 1, 2) result
4 from test;