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
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Point out the difference between user tables and data dictionary?
how to join query for one source type is oracle another source type is sql server ?
Why oracle is used?
How to use in conditions in oracle?
How to run create database statement again?
6. Display the client name and order date for all orders using the traditional method.
What are the execution control statements?
What are oracle functions?
What is the disadvantage of User defind function?
Give the various exception types.
What do you know about normalization? Explain in detail?
What is set verify off in oracle?
How to fetch the row which has the max value for a column?
Explain the difference between replace() and translate() functions in oracle?