what are the advantages of cursors than procedures?
Answers were Sorted based on User's Feedback
Answer / kumar srinivasalu
Cursors can be used to pass the parameters to procedures
and functions. The Single cursor used to multiple
updatation and used multiple queries at run time
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / somashekhar m
By using cursors It is possible to fetch row by row, when
user might want to work with rows one at a time. But not
possible with SQL standard statements it is not possible to
go row by row fetching.
A cursor can be defined as is a set of rows together with a
pointer that identifies a current row.
in ACID cursor works for consistency of the data.
Is This Answer Correct ? | 12 Yes | 2 No |
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#
trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.
What is the difference between the implicit and explicit cursors?
What is difference between TRUNCATE & DELETE?
16 Answers Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,
What is sql query optimization?
what is a composite primary key ? : Sql dba
What is a temp table?
how to get a list of columns in an existing table? : Sql dba
What is a package ? What are the advantages of packages ?
What is sql*loader and what is it used for?
What is rownum in sql?
When do we use triggers?