select replace ('ABCD,EFGH,IJKL,PQRS',',','')

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"

Question Posted / ramya

7 Answers
11558 Views
British Telecom BT, I also Faced
E-Mail Answers

Answer Posted / ramya

select replace ('ABCD,EFGH,IJKL,PQRS',',','') from Customers;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a nvl function? How can it be used?

977

Compare and contrast between sql and sql server and explain its various functions?

935

How to convert numbers to characters in oracle?

992

How can we find out the current date and time in oracle?

1060

How to generate query output in html format?

1060

What is program global area (pga) in oracle?

986

what is the dual table in oracle?

949

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

985

How index is implemented in oracle database?

970

what happened to the global index when I truncate the data in one of the partition?

1987

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

968

How can I get column names from a table in oracle?

1007

Explain oracle data types with examples?

980

Explain joins in oracle?

998

Does oracle partitioning improve performance?

961