Interested to Buy Any Domain ? << Click Here >> for more details...
difference between imlicit cursor and explicit cursor ?
- 5 Answers
- 9432 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vipin kumar ( m.c.a)
1. Implicit cursor:- means predefine cursor. Its attributes
starting with the sign % like that %ROWCOUNT, %ISOPEN etc.
2. Explicit cursor:- means created by the user or
programmer. Its attributes starting with the cursor name
then % sign lick that cursorname%ROWCOUNT, cursorname%ISOPEN
etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List out the types of joins.
Can multiple cursors being opened at the same time?
What are the different types of failures that occur in Oracle database?
What is an oracle data file?
WHAT IS ecc 6.0
What is an oracle tablespace?
How many categories of data types?
how to join query for one source type is oracle another source type is sql server ?
How to write a query with a left outer join in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How do I reset a sequence in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is oracle used for?
What is a snapshot in oracle database?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
