Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / ashok

SELECT LENGTH(REGEXP_REPLACE('s1,s2,s3,s4', '[s0-9]', '')) FROM dual

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does an inner join do?

1164


Can %notfound return null after a fetch?

1040


what is foreign key? : Sql dba

1003


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1113


Mention what is the plv (pl/vision) package offers?

1094


What is an ndf file?

977


Why is a primary key important?

1027


how to escape special characters in sql statements? : Sql dba

1020


How to process query result in pl/sql?

1110


What is sql*loader?

1161


What does the sign mean in sql?

968


What is trigger and types?

1006


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4007


How do I filter in sql profiler?

988


What are packages in pl sql and also explain its advantages?

1016