A, B and C in Numeric Spelling [message #286252] |
Fri, 07 December 2007 00:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/70674.jpg) |
rajavu1
Messages: 1574 Registered: May 2005 Location: Bangalore , India
|
Senior Member |
![i.rajavu@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Check how many times A,B nac C are repeated in Numbers .
with NUM_SPELL as
(select spell_number(level) sp from dual connect bY level < 1000 )
select COUNT(DECODE(INSTR(sp,'A'),0,NULL,1)) COUNT_A
from NUM_SPELL
with NUM_SPELL as
(select spell_number(level) sp from dual connect bY level < 1000000000 )
select COUNT(DECODE(INSTR(sp,'B'),0,NULL,1)) COUNT_B,
COUNT(DECODE(INSTR(sp,'C'),0,NULL,1)) COUNT_C
from NUM_SPELL
spell_number Function is by Asktom (with output All CAPS..)
![Thumbs Up](images/smiley_icons/icon_thumbsup.gif)
Rajuvan.
|
|
|
|
|
|
|