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
Changing 10g password in 19c
-
One user may complain about ORA-28008 when changing its old password in
19c. Many users still use the old non case sensitive passwords. Resetting
User Pass...
3 days ago
No comments:
Post a Comment