select length(regexp_replace('s,a,d,abc',',')) counto

write a query to count number of alphabets in given string
for example "APPLE"

write a query to generate sequence from 50 to 100

write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

Question Posted / obulesu

7 Answers
11470 Views
British Telecom BT, I also Faced
E-Mail Answers

Answer Posted / obulesu

select length(regexp_replace('s,a,d,abc',','))
countofcharecter from dual

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to connect asp pages to oracle servers?

1004

Explain integrity constraints?

1056

How to drop a stored function?

1083

How to use in conditions in oracle?

995

Define oracle database

991

What are the four Oracle system processes that must always be up and running for the database to be useable?

954

How to call a stored function in oracle?

950

How to handle a single quote in oracle sql?

971

What do you mean by cdb and pdb in oracle 12c?

1006

What is a lookup table in oracle?

929

Is oracle the best database?

914

How do I manually create a database in oracle?

955

Explain parameter file in oracle.

969

what is port in oracle? how is it related to database application.

1892

Is java required for oracle client?

923