difference between imlicit cursor and explicit cursor ?
- 5 Answers
- 7668 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kiran
implicit generated by oracle server
explicit manually created by programmer to store the result
in the temporary space
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use in conditions in oracle?
What is recovery manager(rman) backup in Oracle?
What privilege is needed for a user to insert rows to tables in another schema?
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 check database size in Oracle?
What happens to the data files if a tablespace is dropped?
How to invoke the data pump export utility?
What are a collation and state the different types of collation sensitivity?
What is a server parameter file in oracle?
How to start an oracle instance?
Explain about functional dependency and its relation with table design?
Can you assign multiple query result rows to a variable?
How to define an oracle cursor variable?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to install oracle odbc drivers?
