Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
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 |
What is oracle analytical function?
What is the quickest way to export a table to a flat file?
How many anonymous blocks can be defined?
what is the difference between functional dependecy and multilevel dependency?
What is an anonymous block?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
Can we create trigger on view in oracle?
Difference between inner join vs where ?
How to view all columns in an existing table?
How to select some columns from a table in oracle?
What is a connect identifier?