create or replace function f1( iip in varchar2,iip2 in char) Return numbe

counting the no.of characters occurs in a string by using
pl/sql function

Question Posted / revathy

1 Answers
6320 Views
TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What does cursor do in sql?

970

What is a string data type in sql?

958

What is varchar used for?

1023

What is normalisation in sql?

1003

What is a database trigger?

1017

Is a view faster than a stored procedure?

900

Is a table valued function object?

959

How can I tell if sql is running?

992

Is nosql faster than sql?

970

What are few of the schema objects that are created using PL/SQL?

968

What is type and rowtype in pl sql?

965

define sql delete statement ? : Sql dba

970

What is compound trigger?

959

What is rollback?

1035

Which function is used to return remainder in a division operator in sql?

1074