Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer Posted / sanjaya
select regexp_count('RAM CHARAN SINGH','s')+1 from dual;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to start a new transaction in oracle?
What is the quickest way to fetch the data from a table?
Explain the difference between sql and oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to define a specific record type?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
List out the components of logical database structure of oracle database.
Is primary key indexed by default in oracle?
How to create an oracle testing table?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Explain what are the uses of rollback segment?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to use "for" statements in oracle?
How to connect to oracle using service name instead of sid?