Chapter 31
Managing Database Objects in Sets
Jonathan Gennick
When I first began my career, I was a programmer operating in a mainframe COBOL environment. We wrote procedural code. Our typical programs were batch programs that read records from a file and processed those records in read–loop. The read–loop contained program logic to identify records of interest and to perform operations on those records. I worked in that environment for several years and I was happy.
In the early 1990s, I was introduced to relational databases and SQL. SQL allows you to work in terms of sets. Suddenly, rather than processing one record a time, I could process an entire set of records with one statement. This led a completely different way of thinking about ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
