Answer / ajit

select 's1,s2,s3,s4' str,
length('s1,s2,s3,s4') - length(replace('s1,s2,s3,s4', ',')) str2
from dual;

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>

Answer / debbie

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

Answer / ashok

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

Does truncate table reset auto increment?

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

Does normalization improve performance?

0 Answers  

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

What are the data types allowed in a table?

3 Answers  

---

how to create a new table in mysql? : Sql dba

0 Answers  

---

What is the need of a partition key?

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

What are all the common sql functions?

0 Answers  

---

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

---

What is latest version of sql?

0 Answers  

---