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 test null values?

1054


Explain the use of Merge statement in oracle 11g

989


What happens if the imported table already exists?

982


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1954


What is execute immediate in oracle?

968


definition of cluster and non-clustered index?

2979


How to convert numbers to characters in oracle?

986


Why do we use coalesce function in oracle?

1071


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1030


How do we display rows from the table without duplicates?

940


How does Oracle guarantee data integrity of data changes?

2350


What is an Oracle index?

1617


What is redo log?

1013


How to export data with a field delimiter?

988


How to turn on or off recycle bin for the session?

1053