Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / nitin vartak

Answer Posted / nitin vartak

select enam ,eempno , (len(phoneno) - len(replace
(phoneno,',',''))) + 1 from TableName

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explian rowid, rownum?

756

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

800

Can we use delete in merge statement?

737

Which kind of parameters cannot have a default value in pl sql?

807

What found sql?

703




How do you optimize a stored procedure query?

739

can sql servers linked to other servers like oracle? : Sql dba

751

what is oracle database ? : Sql dba

740

Mention what does plv msg allows you to do?

857

What is difference between ms sql and mysql?

666

Is oracle sql free?

734

What does := mean in pl sql?

757

What is partition by in sql?

784

Can unique keys be null?

663

How do you use a while loop in pl sql?

722