| A, B and C in Numeric Spelling [message #286252] |
Fri, 07 December 2007 00:38  |
 |
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
|
Senior Member |
|
|
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..)
Rajuvan.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
