Answer Posted / vijay

cursor
open
fetch
close
attributes
%found,
%notfound
%isopen
%rowcount
loop
whlie loop
for loop

Why truncate is faster than delete?

832

---

Can function return multiple values in sql?

778

---

List the ways to get the count of records in a table?

680

---

What is rowid in sql?

689

---

Can we commit inside a trigger?

755

---

How does an execution block start and end in pl sql?

705

---

Which join is default?

728

---

What is union and union all keyword in sql?

740

---

Does inner join remove duplicates?

716

---

What is a crud api?

707

---

What is nested table in pl sql?

777

---

What are the differences between in and exists clause?

818

---

How do I start pl sql?

689

---

what are the join types in tsql? : Transact sql

780

---

What is an invalid partition table?

771

---