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 nayak
1:-select length('apple')
from dual;
o/p:-5
2:-select rownum
from dual
connect by level between 50 and 100;
3:-select replace ('ABCD,EFGH,IJKL,PQRS',',')
from dual;
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Is oracle a relational database?
Can we insert data in view oracle?
What happens to the indexes if a table is recovered?
various types of hints and their usage
Can group functions be used in the order by clause in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to write a left outer join with the where clause in oracle?
What is ceil and floor in oracle?
What is a data lock in oracle?
What is primefaces used for?
In which language oracle has been developed?
What is connection pooling in oracle?
What is oracle thin client?
How can windows applications connect to oracle servers?
What are the execution control statements in oracle?