Answer / sohini

Whenever you issue a SQL statement, the Oracle server opens
a SQL work area in memory in which the command is parsed
and executed. This area is called a cursor.There are two
type of cursors:
Implicit Cursor:PL/SQL declares a cursor implicitly for all
SQL data manipulation statements, including queries that
return only one row.PL/SQL manages this cursorautomatically.
Explicit Cursor:The programmer explicitly declares and
names an explicit cursor for queries that return more than
one row.it is managed by the programmer.
Explicit cursors are used when one wants to do some
processing with a set of rows fetched from a table or
multiple table.They are managed using OPEN,FETCH and CLOSE.
4 attributes are used in both types of cursors:%FOUND,%
NOTFOUND,%ROWCOUNT and %ISOPEN.

Answer / manvendra

USER DEFINED sql WORK AREA FOR QUERY IS CURSOR.

USED TO STORE RESULT SET PROVIDED BY THE QUERY FOR SHORT
AND TEMP BASIS.

MAIN STATES ARE
CLOSE
OPEN
FETCH

26. Display the earliest shipping date in the format: DD/MON/YYYY

5 Answers   Wipro,

---

How to recover a dropped table in oracle?

0 Answers  

---

What happens to the current transaction if the session is killed?

0 Answers  

---

How to export data to a csv file?

0 Answers  

---

What is the difference between a hot backup and a cold backup in oracle?

0 Answers  

---

Will you be able to store pictures in the database?

0 Answers  

---

What are the execution control statements in oracle?

0 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---

What is a Redo Log ?

3 Answers  

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

0 Answers   MCN Solutions,

---

How to convert characters to dates in oracle?

0 Answers  

---