Answer Posted / hari k

set serveroutput on;
declare
cursor c1 is select substr(name1,1,1) from tab1;
v_string tab1.name1%type;
begin
open c1;
loop
fetch c1 into v_string ;
exit when c1%notfound;
dbms_output.put_line(v_string);
end loop;
end;

How to pronounce postgresql?

1051

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1134

---

what is view? : Sql dba

952

---

What does subquery mean in sql?

1045

---

What is data control language (dcl)?

1131

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1057

---

How do you concatenate in sql?

1023

---

What are the different schemas objects that can be created using pl/sql?

1017

---

What is Materialized View? In What Scenario we Use Materialized View?

9503

---

what is normalization? : Sql dba

1078

---

What are sql functions? Describe in brief different types of sql functions?

1097

---

How do I audit the sql sent to the server?

1000

---

Why do we go for stored procedures?

1047

---

How bulk collect improves performance?

995

---

What is varchar used for?

1074

---