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

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

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are a cluster and non-cluster index?

583


How to synchronize 2 schema's objects?

1697


What is recovery manager in Oracle?

601


Explain temporal data types in oracle

619


What are the differences between primary key and unique key?

522






Explain oracle’s system global area (sga).

632


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1215


What is clustered table in Oracle?

652


How to name query output columns in oracle?

696


How do I use os authentication with weblogic jdriver for oracle and connection pools?

586


Why do you create or replace procedures rather that drop and recreate.

553


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1946


What is MTTR advisor in Oracle?

618


What are the various oracle database objects?

686


What types of joins are used in writing subqueries?

573