Learn SQL Programming from the Best Tutors
Affordable fees 1-1 or Group class Flexible Timings Verified Tutors Search in
declare
str varchar2(80):='&str';
ab char:='&ch';
i number;
l number;
c number;
begin
l:=length(str);
for i in 1..l loop
if (substr(str,i,1=ab) then
c:=c+1;
end if;
end loop;
dbms_output.put_line('legnth of the string '||l);
dbms_output.put_line('no.of times repeated '||c);
end;
Find SQL Programming Training near you
Learn from Best Tutors on UrbanPro.
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near you17 Answers
The best tutors for SQL Programming Classes are on UrbanPro
The best Tutors for SQL Programming Classes are on UrbanPro
Book a Free Demo 
0
