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

Does oracle charge for java?

1051

How to get a create statement for an existing table?

961

What is set verify off in oracle?

1090

What happens to the current transaction if a ddl statement is executed?

1006

Explain the types of exception?

1139

What are the types of partitions in oracle?

1032

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

2299

What are triggers in oracle?

1021

How to assign a tablespace to a users in oracle?

1040

Explain oracle left join with an example?

1002

What is a table in oracle?

971

How to view all columns in an existing table?

929

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2108

What is instant client oracle?

1017

How to create a table in a specific tablespace?

966