Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer Posted / joel
select count('ram charan singh') dual;
| Is This Answer Correct ? | 2 Yes | 22 No |
Post New Answer View All Answers
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Explain the use of record option in exp command.
various types of hints and their usage
Can we write dml statement in function in oracle?
How many types of auditing in Oracle?
Difference between the “verify” and “feedback” command?
Explain the use of log option in exp command.
What are the different types of trigger and explain its various uses and functions?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What do database buffers contain?
How to load a large xml file?
How to connect the oracle server as sysdba?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to define default values for formal parameters?
What are set operators?