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;

Can ddl statements be used in pl/sql?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

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

0 Answers  

---

What is auto increment?

0 Answers  

---

---

Does pl sql work in mysql?

0 Answers  

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

What are the different types of dbmss?

0 Answers  

---

who introduced sql?

0 Answers  

---

how many no of table can be join in a sql query.

4 Answers  

---

What are the differences between implicit and explicit cursors?

0 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---