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

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

Question Posted / suresh

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

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

Answer / 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

More SQL PLSQL Interview Questions

How do you identify a primary key?

0 Answers

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers Tech Mahindra,

How does a self join work?

0 Answers

What are the events on which a database trigger can be based?

0 Answers

Why is nosql good?

0 Answers

How do you respond to dementia behavior?

0 Answers

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers

what is bcp? When does it used? : Sql dba