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 information schema in sql?

760

---

What is sequence in sql?

717

---

Define a temp table?

751

---

what is clause? : Sql dba

759

---

What is db journal file?

676

---

---

What is the difference between jpql and sql?

780

---

Is sql a programming?

714

---

What is record type in pl sql?

747

---

How can I make sql query run faster?

751

---

What has stored procedures in sql and how we can use it?

760

---

What is optimistic concurrency control? : Transact sql

743

---

how to enter numeric values as hex numbers? : Sql dba

766

---

What is trigger and how to use it in sql?

723

---

What is bulk compiling in pl/sql.?

794

---

explain commit and rollback in mysql : sql dba

729

---