1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

difference between imlicit cursor and explicit cursor ?

Question Posted / vipin kumar ( m.c.a)

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


Please Help Members By Posting Answers For Below Questions

what is reindexing?

1179

How to define a specific record type?

622

Can we convert a date to char in oracle and if so, what would be the syntax?

550

How to create a server parameter file?

571

How to define a procedure inside another procedure?

545




What are the attributes that are found in a cursor?

650

What is blob data type in oracle?

560

What is a subquery in oracle?

578

What is an oracle table?

556

1) Does oracle have any table which contain all the exceptions and it's code internally?

1282

Is oracle a language?

522

What is merge in oracle?

561

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1788

What is the difference between alert log file and tarce file ?

1634

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1584