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
- 8889 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 |
What is trigger types of trigger?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
How many types of indexes are there in sql?
what is msql? : Sql dba
How is sql used in oracle?
What is the difference between an inner join and an outer join?
Can we create foreign key without primary key?
What is full join in sql?
How to select unique records from a table?
How to run sql statements with oracle sql developer?
What trigger means?
Why should I use postgresql?
-
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)
