difference between imlicit cursor and explicit cursor ?

Answer Posted / abhishek.421

implicit cursor is a memory space created by oracle..and
explicit cursor is named memory area

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where are the settings stored for each instance in oracle?

619


In the oracle version 9.3.0.5.0, what does each number shows?

740


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1174


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

581


What is the database name in oracle?

529






Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1654


What is proxy method?

536


What do you understand by a database object?

578


Is there an oracle sql query that aggregates multiple rows into one row?

540


How to retrieve data from an explicit cursor?

556


What is an oracle database?

607


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1501


Explain the truncate in oracle?

543


How to create a stored program unit?

572


How do we create privileges in oracle?

580