Real World SQL and PL/SQL: Advice from the Experts

CHAPTER3

Handling Advanced and Complex Data Sets

A data set is a collection of data. In a relational database, the data is saved in columns of the required data type. A column always belongs to one table. In an object-relational solution, the data is saved in an object. A data set can be saved data, inside or outside the database; it can be a data set used while performing a query; or it can be a query result of some form. Sometimes you need to make a decision how to save the data, sometimes getting the result might be complicated, and sometimes you need ways to handle the result set. The problem may arise because the data is big, because advanced ...