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
11904 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

When do you get a .pll extension in oracle?

1188

What is ADDM Advisor in Oracle?

1219

What happens if you use a wrong connect identifier?

1135

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2188

How to create a new user account in oracle?

1062

Oracle

2422

Why do we use bulk collect in oracle?

1103

What is the difference between substr & instr functions?

1292

How to create an oracle database?

1099

How do you store pictures in a database?

1057

What is set operator oracle?

1034

How to open a cursor variable?

1084

What are the data types in oracle?

1095

What is the usage of synonyms?

1210

How data locks are respected in oracle?

1107