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

How does Oracle guarantee data integrity of data changes?

1938

What is recovery manager(rman) backup in Oracle?

629

How do I limit the number of oracle database connections generated by weblogic server?

555

please explain.. DB architecture ...

1568

Differentiate between translate and replace?

633

What are the oracle built-in data types?

566

What are the data types in oracle?

552

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1448

How to define a sub function?

671

defination of bitmap index

1631

How do I uninstall oracle 11g?

565

What is hash cluster in oracle?

596

What privilege is needed for a user to query tables in another schema?

510

How to create a table index?

568

What is oracle rowcount?

580