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
11481 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 subquery in oracle?

1043

How to drop an existing view in oracle?

905

What are the different types of synonyms?

1078

What are transaction isolation levels supported by oracle?

997

How to synchronize 2 schema's objects?

2117

Explain the features of oracle?

991

Explain the difference between sql and oracle?

1026

What is columnar storage what is the advantage?

985

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2434

What is Trigger in Oracle?

1076

Does oracle partitioning improve performance?

947

Calculate difference between 2 date / times in oracle sql?

987

what is the dual table in oracle?

934

What is flashback in Oracle?

967

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2294