hi4ppl
asked on
How can I grab this in oracle in SQL
Hi,
here is sqlfidlle
http://sqlfiddle.com/#!4/8089b/1
I would like to get the result below out of that...
fist | second
100 | 200
101 | 201
102 | 202
103 | 203
104 | 204
105 | 205
regards
here is sqlfidlle
http://sqlfiddle.com/#!4/8089b/1
I would like to get the result below out of that...
fist | second
100 | 200
101 | 201
102 | 202
103 | 203
104 | 204
105 | 205
regards
What have you tried already, besides 'select * from ....' ?
ASKER
Hi,
I did try select regexp_substr(thatfield,'[ ^,]+]',2,2 ) as a table1 but it only pick if it will be the start if it's at end it won't pick it ...
I did try select regexp_substr(thatfield,'[
select
substr(thatfield,instr(tha tfield,'{n ame') + 6,3) as first,
substr(thatfield,instr(tha tfield,'{n ame') + 10,3) as second
from table1;
substr(thatfield,instr(tha
substr(thatfield,instr(tha
from table1;
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
will the "field" widths alter in the data? e.g.
THATFIELD
{blahblah,77100,6200}{seco ndname,200 001}
{muchlongerstringinthisloc ationwithe mbeddednum bers123nam e,17801,20 1234}
{can spaces exist in this location - question to you,1941,51244}
when preparing sample data make sure it covers all situations (well, at least the most likely)
THATFIELD
{blahblah,77100,6200}{seco
{muchlongerstringinthisloc
{can spaces exist in this location - question to you,1941,51244}
when preparing sample data make sure it covers all situations (well, at least the most likely)