counting the no.of characters occurs in a string by using
pl/sql function
Answer Posted / revathy
create or replace function f1(
iip in varchar2,iip2 in char)
Return number
is
tot number;
Begin
select (length(iip)-length(replace(iip,iip2))) into tot
from dual;
return tot;
end;
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
The select into statement is most often used to create backup copies of tables or for archiving records?
What is pl sql collection?
What is difference between inner join and self join?
What is not in sql?
How to look at the current sql*plus system settings?
How to use boolean type in select statement?
What is the usage of sql functions?
How do you use a while loop in pl sql?
What is difference between primary and secondary key?
Why we use sql profiler?
how can we repair a mysql table? : Sql dba
is mysql query is case sensitive? : Sql dba
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is the difference between clustered and non-clustered index in sql?
What is before trigger?