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 the default isolation level in sql server? : Transact sql

1023

---

how to create a table index in mysql? : Sql dba

1061

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

Can we commit in trigger?

978

---

What is procedure explain with example?

961

---

What operators deal with null?

1107

---

How do you update a value in sql?

1043

---

How many row comparison operators are used while working with a subquery?

1030

---

how to use 'mysql' to run sql statements? : Sql dba

1053

---

How to run pl sql program in mysql?

1020

---

What program will open a mdb file?

964

---

Can we rollback after truncate?

1031

---

Can a select statement fire a trigger?

1163

---

How long will it take to learn pl sql?

936

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

952

---