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

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

546

---

what is a view? : Sql dba

633

---

How do I view a sql trace file?

564

---

Is there any restriction on the use of union in embedded sql?

667

---

what are myisam tables? : Sql dba

548

---

---

What is dense_rank in sql?

539

---

Can we use insert statement in function?

514

---

What is the order of sql select?

571

---

What is difference between ms sql and mysql?

474

---

Does access use sql?

555

---

What is multiple partition?

537

---

Why should I use postgresql?

561

---

What are joins in sql?

534

---

Which normal form is best?

511

---

How many types of tables are there?

500

---