Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

State the difference between implict and explict cursor's?

Answer Posted / swapna

Implicit Cursor are declared and used by the oracle
internally. whereas the explicit cursors are declared and
used by the user.

more over implicitly cursors are no need to declare oracle
creates and process and closes autometically. the explicit
cursor should be declared and closed by the user.

More over Explicit Cursors were used to retrieve values
from two or more rows.

Is This Answer Correct ?    28 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to link two groups inside a cross products after the cross products group has been created?

953


Can you inner join the same table?

934


Why use stored procedures?

1018


When you have to use a default "rollback to" savepoint of plvlog?

1123


how to load data files into tables with 'mysqlimport'? : Sql dba

1032


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

988


What is primary key and foreign key?

915


What is the difference between the sql*loader and import utilities? : aql loader

976


What is case function?

988


what is oltp (online transaction processing)? : Sql dba

1013


How to connect a sql*plus session to an oracle server?

1080


How do you truncate?

854


What is sql profiler in oracle?

1012


What will you get by the cursor attribute sql%notfound?

1012


What is the most important ddl statements in sql are?

946