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
- 7201 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhakti
select length(trim('ram charan singh')) - length (replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
| Is This Answer Correct ? | 19 Yes | 3 No |
Answer / sanjaya
select regexp_count('RAM CHARAN SINGH','s')+1 from dual;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to drop an index in oracle?
How to use values from other tables in update statements using oracle?
Explain a data segment?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
List out the difference between commit, rollback, and savepoint?
what is Single Byte Overhead...?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Differentiate between post-database commit and post-form commit?
What is the difference between RBBMS & DBMS?
DBMS vs. RDBMS
How many memory layers are in the shared pool?
Oracle General 
