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;

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

What is Data Concarency and Consistency?

1 Answers  

---

What are the subsets of sql?

0 Answers  

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

Enlist the advantages of sql.

0 Answers  

---

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

Is sql a scripting language?

0 Answers  

---

how to include numeric values in sql statements? : Sql dba

0 Answers  

---

Which one is better subquery or joins?

0 Answers  

---

What is normalisation in sql?

0 Answers  

---

What is the process of debugging?

0 Answers  

---