Home » Other » Community Hangout » A, B and C in Numeric Spelling
A, B and C in Numeric Spelling [message #286252] Fri, 07 December 2007 00:38 Go to next message
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..)

Thumbs Up
Rajuvan.
Re: A, B and C in Numeric Spelling [message #286253 is a reply to message #286252] Fri, 07 December 2007 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still masturbating?

Regards
Michel
Re: A, B and C in Numeric Spelling [message #286256 is a reply to message #286252] Fri, 07 December 2007 00:54 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

YOYO

Thumbs Down
Rajuvan.
Re: A, B and C in Numeric Spelling [message #286287 is a reply to message #286256] Fri, 07 December 2007 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I now know why there is always a hand in your signature.

Regards
Michel
Re: A, B and C in Numeric Spelling [message #286297 is a reply to message #286252] Fri, 07 December 2007 02:19 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

You are a genius Michel !!!!

( No offence is meant )

Cool
Rajuvan
Previous Topic: Don't know if anyone here plays chess...
Next Topic: My birthdate using sysdate - entire life :)
Goto Forum:
  


Current Time: Thu Mar 28 07:26:51 CDT 2024