Answer Posted / madhuri

We can create cursor with parameters using parameterized
cursors.We declare the cursor in the deceleration section
with parameters.
Syntax: cursor <cursor_name>(parameters) is <select_stmt>

We pass values to these cursors while opening it.
open c1(100,'Computers');

What is number function in sql?

956

---

Does a user_objects view have an entry for a trigger?

1002

---

explain mysql aggregate functions. : Sql dba

980

---

Can we insert delete data in view?

942

---

What is basic structure of pl sql?

1062

---

Which command is used to delete a package?

1153

---

What is the difference between subquery and correlated query?

1054

---

How show all rows in sql?

1006

---

how to return query output in html format? : Sql dba

1067

---

How do I restart sql?

954

---

What is the purpose of primary key?

1012

---

When should I use nosql database?

998

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1201

---

Is pl sql better than sql?

1015

---

How do I create an index in word?

1025

---