New Release White Paper through Contractors Network
Contractors Network is pleased to announce the latest free of charge release into our extensive Oracle Apps related White Paper Library of:
“A Structured Approach to SQL Query Design”
Authored By Brendan Furey
About Brendan;
Brendan is an Oracle Applications Consultant with over nineteen years Oracle experience, across a wide range of projects and industries. He has worked with many Oracle modules, including Financials, Supply Chain, and CRM, up to 11.5.10. He is technically oriented, and has expert level knowledge of most of the Oracle development tools, as well as Unix and other tools, and also has good functional knowledge.
Recent projects have included: implementation of multi-org and intercompany invoicing within an existing single-org implementation; development of complex interfaces between Oracle instances using different CRM modules, with PO, AP AR; integration design (using middleware) for a European implementation of Oracle ERP (back-office) along with Siebel (front-office) and other systems.
The Purpose of Brendan’s Paper;
The purpose of this document is to describe a structured, graphical approach to the design of SQL queries that may be a useful way of handling complexity without reverting to procedural design. It focuses on sub query structure and join orders, rather than on other areas such as grouping and aggregation, or design patterns. The author has used it to design complex queries with up to 46 table instances, and the approach is demonstrated using a real (rather simpler) example of a custom report within Oracle’s Order Management and Inventory modules (see REF-2 for Oracle’s table specifications).
If you would like request a copy please email myself on rebecca.bragg@oraclecontractors.com or register via the White Paper library and request your copy today.