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;

What is foreign key sql?

1034

---

Differentiate between pl/sql and sql?

1209

---

What does pl sql developer do?

974

---

how many columns can be used for creating index? : Sql dba

984

---

Can we use pl sql in sql server?

1131

---

What are the disadvantages of not performing database normalization?

1212

---

What is the difference between subquery and correlated query?

1111

---

What is the difference between a query and a report?

1050

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1216

---

what is top in tsql? : Transact sql

1167

---

What is sp_helptext?

1104

---

What is error ora-01000: maximum open cursors exceeded

1204

---

what are properties of a transaction? : Sql dba

1132

---

What are the two types of exceptions.

1217

---

What is the difference between rollback and rollback to statements?

1097

---