Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 7 Answers
- 11682 Views
- British Telecom BT, I also Faced
- E-Mail Answers
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
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How is it different from a normal table?
How to create a table interactively?
Why does for update in oracle 8 cause an ora-01002 error?
Are truncate and delete commands same? If so why?
In which language oracle has been developed?
How a tablespace is related to data files?
What is a nested table?
how to handle exceptions in post production
Point the difference between translate and replace?
How to create lov dynamically at runtime & attach to text field?
How many categories of data types in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What are the various types of snapshots ?
How to list all indexes in your schema?
