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 / chiranjeevi

select level+49 from dual connect by level<=100

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the oracle differences between nvl and coalesce

524


How to use values from other tables in update statements using oracle?

576


What is connection pool in oracle?

568


how the indexes are stored in the Oracle Database?

1747


What is oracle sid?

513






How to delete all rows a table in oracle?

631


How do I find my oracle client driver version?

538


How to empty your oracle recycle bin?

579


How to define a specific record type?

632


What is java oracle used for?

533


Explain alias?

722


What is the parameter mode that can be passed to a procedure?

581


Explain a data segment?

660


How to pass parameters to procedures in oracle?

576


What are the differences between lov and list item?

567