Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

Do we need to create index on primary key?

0 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

What is a schema sql?

0 Answers  

---

---

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

28 Answers   Alps, Aricent, Bank Of America, Wipro,

---

what is the functionality of the function htmlentities? : Sql dba

0 Answers  

---

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

What are user defined functions?

0 Answers  

---

Is record in pl sql?

0 Answers  

---