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.
- 4 Answers
- 9080 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ajit
select 's1,s2,s3,s4' str,
length('s1,s2,s3,s4') - length(replace('s1,s2,s3,s4', ',')) str2
from dual;
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / prashant
14:41:23 SQL> SELECT regexp_count ('s1,s2,s3,s4', ',')
14:41:24 2 FROM DUAL;
REGEXP_COUNT('S1,S2,S3,S4',',')
-------------------------------
3
Elapsed: 00:00:00.00
14:41:26 SQL>
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / 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 |
Answer / ashok
SELECT LENGTH(REGEXP_REPLACE('s1,s2,s3,s4', '[s0-9]', '')) FROM dual
| Is This Answer Correct ? | 1 Yes | 0 No |
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Can we call dml statement in function?
What is the difference between DELETE, TRUNCATE, and DROP?
What is sql profiling in oracle?
How to run pl sql program in mysql?
How do you copy a table in sql?
What is materialised View?
How do you explain an index?
Does sql require a server?
What is use of package in pl sql?
What is the difference between count 1 and count (*) in a sql query?
explain mysql aggregate functions. : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
