Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5401


Point out the difference between user tables and data dictionary?

976


how to join query for one source type is oracle another source type is sql server ?

2418


Why oracle is used?

1045


How to use in conditions in oracle?

1045


How to run create database statement again?

1144


6. Display the client name and order date for all orders using the traditional method.

2299


What are the execution control statements?

1060


What are oracle functions?

1021


What is the disadvantage of User defind function?

2285


Give the various exception types.

987


What do you know about normalization? Explain in detail?

942


What is set verify off in oracle?

1092


How to fetch the row which has the max value for a column?

994


Explain the difference between replace() and translate() functions in oracle?

1026