What are %type and %rowtype for?

1052

---

What is a sql profiler?

1023

---

How to select 10 records from a table?

1157

---

How many times can we commit in a loop?

1017

---

What is data manipulation language?

1187

---

Can you call pl/sql package functions from within a fast formula?

1039

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1059

---

what are different types of keys in sql?

1148

---

Define overloaded procedure?

1078

---

How do we accept inputs from user during runtime?

1062

---

What does the acronym acid stand for in database management?

1032

---

What is the difference among union, minus and intersect?

1000

---

What are the differences between implicit and explicit cursors?

1066

---

Cite the differences between execution of triggers and stored procedures?

1077

---

What is a recursive stored procedure?

1181

---