i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6
Answers were Sorted based on User's Feedback
Answer / kavitha nedigunta
select count(*) from(
select trim(regexp_substr(initcap(phoneno),'[^,]+',1,level)) as phoneno
from testphone
connect by level <= length(regexp_replace(phoneno,'[^,]'))+1
)a
it will work in oracle 10g on words.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / sarath
select length(phoneno)-length(replace(phoneno,','))+1 as TOTALCOUNT from <tablename>
For few friends who sent count(*) I wanna say something that
Its a SINGLE (FIELD VALUE)STRING CONTAINING MULTIPLE PHONENOs
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / nitin vartak
select enam ,eempno , (len(phoneno) - len(replace
(phoneno,',',''))) + 1 from TableName
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / venkat
select count(column_name) from table_name;
if u want to count number of phone numbers then use below
from emp table
select count(phno) from emp;
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / rolly
select count(&a) from emp
enter the column name at run time it will give the exact
count.
I have tested it. It works.
Is This Answer Correct ? | 2 Yes | 4 No |
What is the difference between numeric and autonumber?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is duration in sql profiler trace?
What is ttitle and btitle?
How do I run a sql trace?
What is t sql used for?
Do stored procedures prevent sql injection?
How do you get all records from 2 tables. Which join do you use?
What are the various restrictions imposed on view in terms of dml?
What do you understand by pl/sql cursors?
what is the bond code in materialized view?
What are sql built in functions?