select length('s1,s2,s3,s4')-length(replace('s1,s2,s3,s4�

if a string is there like s1,s2,s3,s4.How to find count of
commas in this.

Question Posted / debbie

Answer Posted / debbie

select
length('s1,s2,s3,s4')-length(replace('s1,s2,s3,s4',',')) as
Count_comma from dual

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is partition in sql query?

720

Are views faster than queries?

725

How many commands are in sql?

716

How many sectors are in a partition?

744

What are the types of records?

743

What is a parameter query?

820

What is cursor and its types?

716

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1000

Why we use joins in sql?

723

What are the benefits of pl sql?

767

how many groups of data types? : Sql dba

728

Does sql use python?

756

How many tables can a sql database have?

710

What's the difference between a primary key and a clustered index?

717

What are the subsets of sql?

754