1

Topic: Digit presence in line

Whether how to learn there is a digit in line?

2

Re: Digit presence in line

Whether

iv_roman_vl wrote:

How to learn there is a digit in line?

In binary string?

3

Re: Digit presence in line

iv_roman_vl;
regexp_like, enclosed translate.

4

Re: Digit presence in line

AmKad;
Thanks, understood!)
SELECT REGEXP_INSTR (' Joe Smith, 10045 Berry Lane, San Joseph, CA 91234 ';
' [[:digit:]] ')
AS rx_instr
FROM dual;

5

Re: Digit presence in line

iv_roman_vl;
REGEXP_INSTR (source_string, ' [[:digit:]] ')> 0

6

Re: Digit presence in line

2 wrote:

where nvl (length (translate (str, ' 0123456789 ', ' a ')), 0) <> length (str);
where nvl (length (translate (str, '>>> a <<<0123456789 ', ' a ')), 0) <> length (str);

But all the same :

where translate (str, ' 0123456789 ', ' aaaaaaaaaa ') <> str;

SY.

7

Re: Digit presence in line

Whether

iv_roman_vl wrote:

How to learn there is a digit in line?

one?