Write a query to count a particular character in a string. e.g Return the number of times 'N' appears in string 'NITININ'. The result shoudl be 3.
Solution:
select length('NITININ') - length(replace('NITININ','N','')) from dual
oem cpu jul 23
-
this blog is no longer maintained. go there : OEM patch |
LaurentSchneider.Com (wordpress.com)
6 months ago
No comments:
Post a Comment