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 / 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 the difference between hot backup and cold backup in oracle?

523


Explain the use of file option in exp command.

601


How to convert character types to numeric types?

578


How to commit the current transaction in oracle?

578


How to convert characters to times in oracle?

596






What is a table in oracle?

543


How to add a new column to an existing table with a default value?

548


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1745


What is a data lock in oracle?

615


How can I see all tables in oracle?

542


How to write a left outer join with the where clause in oracle?

629


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1829


How to retrieve data from an explicit cursor?

559


Difference between oracle's plus (+) notation and ansi join notation?

579


What are the uses of linked server and explain it in detail?

588