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 do I run a sql query?

528

---

What is difference between stored procedures and application procedures?

567

---

How many types of indexes are there in sql?

535

---

What is autocommit sql?

538

---

What is pivot query?

591

---

---

What is a trigger in sql?

634

---

Can you skip header records while loading? : aql loader

539

---

What is compute?

555

---

List out the acid properties and explain?

560

---

Can pl sql procedure have a return statement?

548

---

Is it possible to create the following trigger: before or after update trigger for each row?

718

---

Is sql workbench free?

528

---

Does pl sql work in mysql?

532

---

How to set up sql*plus output format in oracle?

593

---

How does pl sql work?

520

---