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;
/

How do I run a sql query?

1022

---

Is left join same as join?

997

---

When is the explicit cursor used ?

1035

---

What are the types of subqueries?

1055

---

What do we need to check in database testing?

1018

---

What is the mutating table and constraining table?

1026

---

how to add a new column to an existing table in mysql? : Sql dba

1073

---

What is cursor in pl sql with examples?

1034

---

What is join view in sql?

945

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2279

---

What is your daily office routine?

2271

---

Is trigger a stored procedure?

934

---

what is isam? : Sql dba

1009

---

Explain the rollback statement?

1013

---

How do you modify a trigger?

928

---