August 2002
Intermediate to advanced
528 pages
10h 12m
English
The next chapter will cover views and sequences. A view is an important tool for the business analyst. It is a SELECT statement that resides in the database. Views are a very common tool for creating virtual record sets. Sequences are a database tool that returns unique and unused numbers to the calling object. It is a great tool for generating artificial primary keys, payroll numbers, or account numbers.