O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Business Objects

One of the problems with modern databases is that they can be very complex, especially ERP systems. These databases can consist of scores of tables. The systems are very broad in functionality and are designed to work for any type of business. The systems support the day-to-day work of a business. However, they are not designed to provide business information. I use an ERP system at the company for which I work and it is common to join 10–12 tables and write SQL statements of 50–60 lines. Needless to say, it is extremely difficult to write SELECT statements for these types of databases. Small changes in the desired information can require hours for the business analyst to write and test the revised statements. It is a far more ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required