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 a join? : Sql dba

1035

---

What is function and procedure?

1031

---

How do I create a sql database?

996

---

How do you identify a primary key?

1063

---

How can you know that statistics should be updated?

1079

---

What is pl sql in oracle?

1041

---

What is sql and also describe types of sql statements?

1066

---

Can dml statements be used in pl/sql?

1079

---

Is like operator in sql case sensitive?

1025

---

How to run pl/sql statements in sql*plus?

1079

---

What are the two types of exceptions in pl/sql?

1052

---

What is sql*loader?

1188

---

Does a join table need a primary key?

953

---

What is difference between nchar and nvarchar?

1026

---

What are the different set operators available in sql?

1026

---