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
How to bring a tablespace online?
What is a system tablespace and when it is created?
What are the differences between date and timestamp in oracle?
Explain about your project and its relation to the current job position you are applying to?
Is truncate autocommit in oracle?
What would you do with an in-doubt distributed transaction?
What is the oracle implicit cursor?
How data locks are respected in oracle?
How to check your oracle database 10g xe installation?
What is rowid and rownum in oracle?
what are the default admin accounts in Oracle 10g ?
How to run create database statement?
What is a nested table?
What is a nested table and how is it different from a normal table?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?