State the difference between implict and explict cursor's?
- 7 Answers
- 20721 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
Can we create clustered index without primary key?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is coalesce in sql?
What is java sql package?
Is sql an operating system?
What are the sql versions?
Define the select into statement.
How to create your own reports in sql developer?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Can we rename a column in the output of sql query?
Is crud a cuss word?
Which query operators in sql is used for pattern matching?
What is sql catalog?
what is rollback? : Sql dba
What are some predefined exceptions in pl/sql?
