Updating sql record

In this chapter, you learn how those types let you reference and manipulate collections of data as whole objects.

You also learn how the datatype is an ordered group of elements, all of the same type.

You can define collection types in a procedure, function, or package.

You can pass collection variables as parameters, to move data between client-side applications and stored subprograms.

It is rare, indeed, to find a PL/SQL program that does not either read from or make changes to tables in a database.

Tables are made up of rows of data, each consisting of one or more columns, so it stands to reason that Oracle Database would make it as easy as possible to work with those rows of data inside a PL/SQL program.

And it does precisely that through its implementation of the datatype, such as a number or string.

The Client Data Set/Provider architecture allows you to specify a primary update table (and advanced features actually not covered in the book) and also customize the updates' SQL, as we partially saw in Chapter 14 and we'll further explore in Chapter 16, "Multitier Data Snap Applications." ADO supports an equivalent to cached updates called batch updates, which are similar to the BDE approach.The data or information for the database are stored in these tables. Tables are uniquely identified by their names and are comprised of columns and rows. Ambrose Bierce Many programming techniques use collection types such as arrays, bags, lists, nested tables, sets, and trees.To support these techniques in database applications, PL/SQL provides the datatypes , which allow you to declare index-by tables, nested tables and variable-size arrays.Answer 2: To make it possible for the plch_proc procedure to compile without error, change “AND” to “OR” in the WHEN clause of the exception section.


Leave a Reply