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;

What is row_number () in sql?

974

---

Can we use delete in merge statement?

1033

---

What is sqlite used for?

985

---

How to run sql statements through the web interface?

1030

---

What makes a good primary key?

1025

---

Why is the cursor important?

1031

---

how to convert numeric values to character strings? : Sql dba

1097

---

What packages are available to pl/sql developers?

1040

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1045

---

what is unique key constraint? : Sql dba

1028

---

What is left join example?

940

---

How do you use a while loop in pl sql?

999

---

What is sql data?

980

---

Can 2 queries be executed simultaneously in a distributed database system?

1136

---

what are aggregate and scalar functions? : Sql dba

1051

---