Interested to Buy Any Domain ? << Click Here >> for more details...
State the difference between implict and explict cursor's?
- 7 Answers
- 23132 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are the types of variables use in pl sql?
What is union, minus and interact commands?
Why use subqueries instead of joins?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What are the different type of joins in sql?
What does data normalization mean?
Why do we go for stored procedures?
How do you write a subquery?
What are the two parts of design view?
What is a sql schema used for?
What is the difference between delete and truncate statement in sql?
What is difference between rank () row_number () and dense_rank () in sql?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is the file extension for sql database?
Can you select everything, but 1 or 2 fields, without writer's cramp?
