Interested to Buy Any Domain ? << Click Here >> for more details...
difference between imlicit cursor and explicit cursor ?
- 5 Answers
- 9602 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
What are the ways tablespaces can be managed and how do they differ?
Why packages are used in oracle?
What is meant by joins? List out the types of joins.
List out the types of joins.
What is ordinary table in oracle?
How to estimate disk space needed for an export job?
What is meant by joins?
What is the difference between translate and replace?
How to connect the oracle server as sysdba?
Explain the difference between replace() and translate() functions in oracle?
How to write date and time literals in oracle?
How to loop through data rows in the implicit cursor?
What are the different types of trigger and explain its various uses and functions?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to list all tables in your schema?
