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

What is a read only transaction in oracle?

1029


How to write date and time interval literals in oracle?

1036


How to add a new column to an existing table in oracle?

1141


What is the usage of synonyms?

1143


What is oracle database 10g express edition?

1120


What are temporal data types in oracle?

1128


How to delete a column in an existing table in oracle?

1073


Explain the use of control file?

1113


Is the After report trigger fired if the report execution fails ?

2915


What to do if the binary spfile is wrong for the default instance?

1071


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2464


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2222


How to use windows user to connect to the server?

990


What is a server parameter file in oracle?

1059


How to create a table interactively?

1097