Home » SQL & PL/SQL » SQL & PL/SQL » counting function (Oracle0i,windows)
counting function [message #351487] Wed, 01 October 2008 02:00 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I need to count the letters per word.

For example

'seg,kil,loi,loo'

we need to calculate the number of comma in this word from sql statements not using PL/SQL statements.


Thanks,
Michael.
Re: counting function [message #351493 is a reply to message #351487] Wed, 01 October 2008 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use LENGTH and REPLACE.

Regards
Michel
Re: counting function [message #351497 is a reply to message #351493] Wed, 01 October 2008 02:42 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Michel Cadot wrote on Wed, 01 October 2008 08:30
Use LENGTH and REPLACE.



Not sure they were available in version Oracle0i,windows Smile
Re: counting function [message #351505 is a reply to message #351497] Wed, 01 October 2008 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing

Not sure too.

Regards
Michel
Re: counting function [message #351506 is a reply to message #351487] Wed, 01 October 2008 03:45 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
The oracle version is 9i not 0i.
Re: counting function [message #351507 is a reply to message #351506] Wed, 01 October 2008 03:52 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Have a Look at This.


http://www.orafaq.com/forum/t/71171/0/


Regards,
Rajat Ratewal
Previous Topic: Non used Index listing ..
Next Topic: User vs System Function Execution Time
Goto Forum:
  


Current Time: Fri Dec 02 12:36:44 CST 2016

Total time taken to generate the page: 0.10359 seconds