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;

explain advantages of innodb over myisam. : Sql dba

0 Answers  

---

How can the performance of a trigger be improved?

0 Answers  

---

Can we write dml inside a function in sql server?

0 Answers  

---

What does an inner join do?

0 Answers  

---

What is nosql example?

0 Answers  

---

---

Its possible to add more than one primary key for the table

4 Answers  

---

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

What are sql injection vulnerabilities?

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

Can you have a foreign key without a primary key?

0 Answers  

---

Can we join two tables without common column?

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---