select count('ram charan singh') dual;

Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3

Question Posted / joel

Answer Posted / joel

Is This Answer Correct ?

2 Yes

22 No

Please Help Members By Posting Answers For Below Questions

What are the differences between date and timestamp in oracle?

1055

Is truncate autocommit in oracle?

1094

How to count duplicated values in a column in oracle?

1053

What is a proxy object?

1073

How to create a new user account in oracle?

1025

Explain about functional dependency and its relation with table design?

1020

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2834

What is an oracle database table?

1019

What are the general rules on data consistency?

1016

What is the difference between substr & instr functions?

1237

How to pass parameters to procedures in oracle?

1048

How to convert characters to times in oracle?

1026

How index is implemented in oracle database?

1011

What is blob datatype?

1134

What are the parameters that we can pass through a stored procedure?

1070