Answer Posted / dinesh

// in SQL:------------------------------------------
Select length('hello')-length(replace('hello','l','')) From
DUAL;

// IN PL/SQL:-------------------------------------------

create or replace Procedure count_char(name varchar2,c varchar2) IS
m number(11):=0;
d number(11);
a number(11);
b number(11):=1;
BEGIN
a:=length(name);
for i in 1..a
LOOP
IF INSTR(NAME,c,b)>=1 THEN
d:=INSTR(NAME,c,b);
m:=m+1;
b:=d;
END IF;
b:=b+1;
END LOOP;
DBMS_OUTPUT.PUT_LINE('count of '||' '||c ||' '||'is'||' '|| m||' '||'in'||' '||name);
end;

What does fetching a cursor do?

1096

---

What is mutating table error?

1192

---

Explain table and field in sql?

1068

---

how do you tune the slow running queries in oracle db , explain the methodology

2823

---

Explain what is rdbms?

1043

---

What is rank () in sql?

952

---

Can a varchar be a primary key?

1012

---

What is sql and also describe types of sql statements?

1068

---

What are stored procedures used for?

1004

---

Is pl sql different from sql?

1005

---

Does pdo prevent sql injection?

935

---

Why does sql need a server?

1045

---

How does cross join work?

961

---

what is the difference between char and varchar data types? : Sql dba

1127

---

What is execute immediate?

1089

---