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"

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 start instance with a minimal initialization parameter file?

542


What is a tns file?

502


interview questions with answer for cts

2090


What are privileges and grants?

574


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1213






How to compare dates in oracle sql?

659


Can a formula column be obtained through a select statement ?

1847


Does facebook use oracle?

581


please explain.. DB architecture ...

1568


What is columnar storage what is the advantage?

546


Why oracle is used?

582


How to store pictures on to the database?

532


Explain the dml?

602


Differentiate between function and procedure in oracle.

561


What are the execution control statements in oracle?

606