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');

How do you select unique values in sql?

932

---

What do we need to check in database testing?

963

---

what is single byte over head in oracle..?

2337

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

984

---

How to look at the current sql*plus system settings?

1076

---

What are string functions in sql?

1168

---

How many types of keys are there in sql?

985

---

What is trigger in sql?

1026

---

how to use 'mysql' to run sql statements? : Sql dba

982

---

How do you write a subquery?

960

---

How to load data with sql*loader?

993

---

Mention what does plv msg allows you to do?

1053

---

What mean sql?

950

---

What are the types pl/sql code blocks?

1066

---

what is the use of double ampersand (&&) in sql queries?

1114

---