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
6408 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

how can we repair a mysql table? : Sql dba

956

Is pl sql a scripting language?

1012

What is trigger in sql? Explain

974

What is pl sql architecture?

944

How to set up sql*plus output format in oracle?

1013

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1151

What is a column in a table?

1106

Is time a data type in sql?

887

What is a crud api?

938

What is primary key and unique key?

1097

what is offset-fetch filter in tsql? : Transact sql

930

What is sql and db2?

979

What is having clause in sql?

946

What is auto increment in sql?

1096

what is the difference between a web-garden and a web-farm? : Sql dba

1062