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 does (+) mean in sql joins?

1116

---

what are the advantages and disadvantages of views in a database? : Sql dba

1068

---

What is loop in pl sql?

1078

---

How do you select unique values in sql?

1042

---

what happens if null values are involved in expressions? : Sql dba

1089

---

How many types of keys are there in sql?

1084

---

what is auto increment? : Sql dba

1049

---

Is sql an operating system?

1071

---

Explain the components of sql?

1106

---

What is sql scripting?

1189

---

What is sql select statement?

1080

---

Which is the correct statement about truncate and delete?

1166

---

what are ddl statements in mysql? : Sql dba

1261

---

Which are the different case manipulation functions in sql?

1075

---

What are views in sql?

1035

---