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;

How do I view stored procedures?

973

---

How is sql used in oracle?

1005

---

What is a left join?

954

---

What is sql key?

989

---

How do you pronounce sql?

1008

---

Can a composite key be null?

978

---

How to pipe multiline string to isql?

1005

---

What is a rank in sql?

963

---

Can unique keys be null?

908

---

What is the use of index in sql?

1017

---

What is difference between my sql and sql?

1069

---

what are myisam tables? : Sql dba

1032

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1079

---

What are types of indexes in sql?

1082

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

---