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...

what are the different types of cursors? explain?

Answer Posted / srilakshmi paleti

1)Implicit cursor
2)Explicit Cursor

EXPLANATION OF
1)IMPLICIT CURSOR : When ever user performs any DML
operation automatically implicit cursors will raise. User
noneed to create,open,fetch,close the cursor.In PLSQL
select statement also it will work.

2)EXPLICIT CURSOR: User has to create,open,fetch and close
the cursor.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain user account with reference to oracle.

1031


What is the fastest query method to fetch data from the table?

1418


How to convert character types to numeric types?

1193


Query to retrieve record for a many to many relationship ?

2576


what are archived logs?

2260


How to insert a record into a table?

1122


How to connect to the server with user account: sys?

1063


What is an oracle database?

1111


How translate command is different from replace?

1142


Is the After report trigger fired if the report execution fails ?

2955


How to delete all rows a table in oracle?

1119


Explain the use of indexes option in imp command.

1264


WHAT IS ecc 6.0

2205


List the types of joins used in writing subqueries?

1037


What is where clause in oracle?

1076