Answer / swapna

Implicit Cursor are declared and used by the oracle
internally. whereas the explicit cursors are declared and
used by the user.

more over implicitly cursors are no need to declare oracle
creates and process and closes autometically. the explicit
cursor should be declared and closed by the user.

More over Explicit Cursors were used to retrieve values
from two or more rows.

Answer / l..l.n.reddy

IMPLICT CURSOR:- Automatically porvide by oracle which
perform DML statements. queries returns only one row.

EXPLICT CURSOR:- Defined by user. queries returns more
than rows.

Answer / madhuri

The implicit cursor is used to process INSERT, UPDATE,
DELETE, and SELECT INTO statements. During the processing of
an implicit cursor,Oracle automatically performs the OPEN,
FETCH, and CLOSE operations.

Where as in explicit cursors,the process of its working is
done in 4 steps namely DECLARE a cursor,OPEN a cursor,
FETCH from cursor and CLOSE a cursor.

Answer / selvaraj v , anna university c

Implicit Curosr : When a query return s Single Row Value
then Implicit Cursor is used.
It's return Only One Row. Curosr Name is assigned
Implicitly.

Implicit Cursor used for all SQL Stmts, that,
DECLARE,OPEN,FETCH,CLOSE.

It's defined by the Oracle Server wherenever the Opertions
Single Row.

Implicit Curosrs Automatically provides by Oracle which
performs DML Statements. Qureies return only one row.

We are able to handle NO_DATA_FOUND Exception in implicit
Cursor.

Explicit Curosr :

A subquery returns more than one row Explicit Curosr is
Created.

The rows returned by the query is called Active Set. It's
return multiple rows.

Curosr is assigned Explicitly. It's used to process
Multirow SELECT Statements.

Retrieving multiple rows the Programmer declare cursors
Explicitly.

Explicit Cursors defined by the User. Queries return more
than rows.

We are Not able to handle NO_DATA_FOUND Exception.

Answer / nageswara rao orsu

Implicit cursors: used for all DML statements and
single-row queries
Explicit cursors: used for queries of zero, one, or
more rows

Answer / bhavesh shah

Implicit cursor:- It always return one row, and no loop is
used in.
Explicit cursor:- It returns more than one row and here loop
is used.

Answer / pradeep

Explicit Cursor:-We are not able to Handle NO_DATA_FOUND
Exception.

Implicit Cursor:-We are able to Handle NO_DATA_FOUND
Exception.

What is sql profiling in oracle?

0 Answers  

Which are the different character-manipulation functions in sql?

0 Answers  

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

What is a system versioned table?

0 Answers  

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

Which join condition can be specified using on clause?

0 Answers  

Why schema is used in sql?

0 Answers  

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

What are the dml statements?

0 Answers  

Is oracel sql developer written in java?

0 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

What are all the different normalizations?

0 Answers