Interested to Buy Any Domain ? << Click Here >> for more details...
State the difference between implict and explict cursor's?
- 7 Answers
- 22864 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 is the difference between sql and isql*plus?
What is the difference between a primary key and a unique key?
What are different types of sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
discuss about myisam key cache. : Sql dba
what are ddl statements in mysql? : Sql dba
What is sql comments?
What is duration in sql profiler trace?
Why do we use %rowtype & %type in plsql?
Can 2 queries be executed simultaneously in a distributed database system?
Can we use views in stored procedure?
What is difference between function and trigger?
What are sql constraints?
What does seeding a database mean?
how to get a list of all tables in a database? : Sql dba
