How to get the part of the string?
From: (wrong string) Богомол Александр Анатольевич <bogomol_at_investbank.ru>
Date: Tue, 27 Nov 2001 15:24:20 +0200
Message-ID: <9455EAF0C99FD111B85B0060B067688A05021793_at_E40>
Date: Tue, 27 Nov 2001 15:24:20 +0200
Message-ID: <9455EAF0C99FD111B85B0060B067688A05021793_at_E40>
In additional:
[Quoted] I need to use retrieved numbers for calculating.
So such sql doesn't work
a= 'abcdef';
Select to_number(substr(a,instr(a,'&')+1)) from dual;
When '&' is missed, I get an error.
- Исходное сообщение----- От: Богомол Александр Анатольевич Помещено: 27 ноября 2001 г. 15:16 Помещено в: tools Предмет: How to get the part of the string? Тема: How to get the part of the string?
In additional: I need to use retrieved numbers for calculating. So such sql doesn't work a= 'abcdef'; Select to_number(substr(a,instr(a,'&')+1)) from dual; When '&' is missed, I get an error.Received on Tue Nov 27 2001 - 14:24:20 CET