Answer Posted / a.jyothsna

declare
cursor cur_t is select * from test;

var_t test%rowtype;
begin
open cur_t;
loop
fetch cur_t into var_t;
exit when cur_t%notfound;
dbms_output.put_line('a: ' || var_t.a || ', b: ' ||
var_t.b);
end loop;
end;
/

describe mysql connection using mysql binary. : Sql dba

1047

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1818

---

What do you mean by field in sql?

1069

---

What is compilation error in pl sql?

960

---

What are the usages of sql?

1047

---

What are stored procedures in mysql?

1005

---

What is null in pl/sql?

1047

---

what are the 'mysql' command line arguments? : Sql dba

1121

---

Is json a nosql?

957

---

How do you use a while loop in pl sql?

997

---

What are inner outer left and right joins in sql?

998

---

Is delete faster than truncate?

994

---

How do I partition in sql?

943

---

What are the different types of sql commands?

1109

---

is mysql query is case sensitive? : Sql dba

1076

---