Inserting updating records using pl sql cursor
It is a general concept that encompasses lists, arrays, and other datatypes used in classic programming algorithms. A record is a group of related data items stored in fields, each with its own name and datatype.You can think of a record as a variable that can hold a table row, or some columns from a table row. The following sections discuss PL/SQL collections and records: Although collections have only one dimension, you can model multi-dimensional arrays by creating collections whose elements are also collections.In PL/SQL, we can insert the data into any table using the SQL command INSERT INTO.This command will take the table name, table column and column values as the input and insert the value in the base table.The purpose of the project was to investigate how SQL is embedded in C#.NET database applications as well as Java database applications.
This chapter shows how to reference and manipulate collections of data as local variables.In my T-SQL code I always use set based operations.I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I assume Microsoft created them for a reason so they must have a place where they can be used in an efficient manner.Regardless of your stand on cursors they probably have a place in particular circumstances and not in others.So it boils down to your understanding of the coding technique then your understanding of the problem at hand to make a decision on whether or not cursor based processing is appropriate or not.