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 are the nonstandard string types? : Sql dba

597

---

What are all different types of collation sensitivity?

523

---

When you have to use a default "rollback to" savepoint of plvlog?

712

---

What are expressions?

559

---

Is sql low level language?

570

---

---

Which are the different types of indexes in sql?

549

---

define sql insert statement ? : Sql dba

545

---

what are the different index configurations a table can have? : Sql dba

564

---

Explain about various levels of constraint.

517

---

What is synchronized subquery?

585

---

what is 'mysqld'? : Sql dba

536

---

What are the steps for performance tuning.

833

---

Which table is left in join?

511

---

What sql does db2 use?

534

---

How many developers work on postgresql?

554

---