Interested to Buy Any Domain ? << Click Here >> for more details...
Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
- 3 Answers
- 7460 Views
- I also Faced
- E-Mail Answers
Answer Posted / bhakti
select length(trim('ram charan singh')) - length (replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
How to create id with auto_increment on oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to convert characters to times in oracle?
What is primefaces used for?
Can we store images in oracle database?
What is the difference between truncate & delete command?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Explain cascading triggers.
What is Data Dictionary Cache in Oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is connection pool in oracle?
How do you bind variables in oracle?
does the query needs a hint to access a materialized view?
How to convert a string to a date in oracle database?
What types of joins are used in writing subqueries?
