What’s Next?
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.
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.
