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 is a cursor

Answer Posted / t.r.sekhar

cursor is a temporary buffer used to hold the transactional
data for the manipulation purpose.
data will not permanently stored in database.
it is not reusable.

syntax:
cursor <cursor name> is <select stmt);
we have two types of cursors are there.
1.implicit cursors-automatically created whenever dml
statements are executed.
2.explicit cursors-created by user

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write an sql query to select all records from the table?

1079


How is a PL/SQL code compiled?

1283


what is the syntax for using sql_variant_property? : Transact sql

1084


What is autocommit sql?

1044


What are user defined functions?

1065


What is difference between left and right outer join?

1038


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1162


explain advantages of myisam over innodb? : Sql dba

1111


Can we use loop in sql?

1010


Whis is not false in primary key?

1523


Why is %isopen always false for an implicit cursor?

1151


What is pl sql block in dbms?

1055


How can we find duplicate records in a table?

993


Is sql a scripting language?

1086


What is right join sql?

1013