Re: substr instr
- From: "Jaromir D.B. Nemec" <jaromir@xxxxxxxxxxxx>
- To: <barb.baker@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 28 Jul 2009 21:45:16 +0200
Hello,
Start net counter : 26798, 24794
I need the number after the : but before the comma, for example, 26798
in the last record
if the prefix string is constant you may save one instr...
select substr(eventtext,1,instr(eventtext,',')-1) from (
select replace(eventtext,'Start net counter : ',null) eventtext from
your_table
where eventtext like 'Start net counter : %'
)
regards,
Jaromir
--
//www.freelists.org/webpage/oracle-l
Other related posts:
