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;

Why are cursors used?

0 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

Is sql procedural language?

0 Answers  

---

Can pl sql procedure have a return statement?

0 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

How do we accept inputs from user during runtime?

0 Answers  

---

Name three sql operations that perform a sort.

0 Answers  

---

How do I view a view in sql?

0 Answers  

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

Which is better varchar or nvarchar?

0 Answers  

---

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

---