| Re:Oracle Profi gesucht |  |
select trunc(exp(sum(ln(a)))) as Product from (select regexp_substr( '*2*2*25' ,'[^*]+',1,level) as a from dual
connect by regexp_substr( '*2*2*25' ,'[^*]+',1,level) is not null)
| Thema: |
|
||
| Autor: | Clyde | ||
| Datum: | 11.01.19 12:26 | ||
| Antwort auf: | Oracle Profi gesucht von Jörg Schnettker | ||
select trunc(exp(sum(ln(a)))) as Product from (select regexp_substr( '*2*2*25' ,'[^*]+',1,level) as a from dual connect by regexp_substr( '*2*2*25' ,'[^*]+',1,level) is not null) |
|||
| < antworten > | |||