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

What is use of term?

1008

---

Explain lock escalation? : Transact sql

1142

---

What is character functions?

1016

---

What is sql clause?

993

---

What programs use sql?

941

---

What are the types of operators available in sql?

1009

---

How can we make an if statement within a select statement?

958

---

What is difference between stored procedure and trigger?

1058

---

What are data types in pl sql?

1076

---

What is sql key?

918

---

What are the types of keys?

932

---

What is trigger in sql and its types?

990

---

what is an extent ? : Sql dba

1018

---

How do I partition a table in sql?

1042

---

Write the alter statement to enable all the triggers on the t.students table.

1067

---