Answer Posted / tulsi

There are two types of cursors, Implict Cursor and Explicit
Cursor.
PL/SQL uses Implict Cursors for queries.
User defined cursors are called Explicit Cursors. They can
be declared and used.

What is a parameter query?

636

---

What is an oracle stored procedure?

600

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2015

---

what are the performance and scalability characteristics of mysql? : Sql dba

542

---

Why partition by is used in sql?

564

---

---

What is rollback?

595

---

What is sql deadlock?

575

---

How do I kill a query in postgresql?

563

---

how to use myisamchk to check or repair myisam tables? : Sql dba

517

---

Mention what is the plv (pl/vision) package offers?

647

---

How to Execute a Package in PL/SQL.?

601

---

What is pls_integer in pl sql?

552

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

678

---

Write a unique difference between a function and a stored procedure.

541

---

what is cross join? : Sql dba

582

---