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
How to calculate date and time differences in oracle?
What is the meaning of recursive hints in oracle?
How do I recompile a procedure in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to use group functions in the select clause using oracle?
What is data block in Oracle?
what are actual and formal parameters?
How to initialize variables with default values?
What is Reduced List of Values?
what is meant by magic query
Differentiate between pre-select and pre-query?
What are the varoius components of physical database structure of oracle database?
How do I learn what codesets are available in oracle?
How to call a stored function with parameters?
What is the purpose of tables, private synonyms and public synonyms in Oracle?