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

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3037

---

What is on delete restrict?

998

---

Is grant a ddl statement?

894

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

976

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1078

---

What are the parts of a basic sql query?

960

---

What are pl sql procedures?

1020

---

What is pl sql quora?

1136

---

What is sql constant?

1020

---

What is the basic form of sql query?

933

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1591

---

How do you update f as m and m as f from the below table testtable?

1845

---

what is a constraint? Tell me about its various levels. : Sql dba

981

---

Why use subqueries instead of joins?

1074

---

What is before trigger?

997

---