Table of Contents

Part I: Overview. Introduction. New Features in Oracle Developer Release 6. Part II: Basic Developer Standards. SQL and PL/SQL Standards. What Do You Base a Block on? Forms GUI Standards. Forms Naming Conventions. Where to Put the Code in Forms. Reports Development Standards. Reports Naming Conventions. Part III: Forms Templates. Constructing the Forms Template System. Building a Form Based on a Template. Part IV: Advanced Form Topics. Deploying Forms on the Web. Forms Help Systems. Locator Forms. Multi-Valued Selection Objects. Integrating Forms and Reports. Part V: Reports Topics. Reports--An Overview. The Reports Data Model. The Reports Layout Model. Using and Building Reports Templates. Building a Production Report. Part VI: Developer Tips and Techniques. Interview Questions. Reports Tips & Techniques. Forms Item Tips and Techniques. Forms Block Tips and Techniques. Forms Module Tips and Techniques. Forms Menu Tips and Techniques. Forms System Tips and Techniques. Forms System Tips and Techniques. Appendices: A: Sample Template PL/SQL Library Packages. B: Interview Questions. C: WinHelp Concepts. D: Stepping Through the Report Wizard. E: Performing a Report Audit. F: Report Specifications. G: Oracle White Papers on Web-Deployed Forms.

About the Author

Peter Koletze is a consulting manager who specializes in Designer and Developer work for Millennia Vision Corporation. He is also a Principal Instructor for the company and a member of the Board of Directors of the International Oracle Users Group - Americas. Peter is a frequent contributor to national and international Oracle newsletters and user group conferences; his paper on Developer and Designer help systems won the ODTUG 1999 Editor's Choice Award.
http://ourworld.compuserve.com/homepages/Peter_Koletzke.

Millennia Vision Corporation (MVC) is a new breed of business consulting firm, dedicated to improving its clients' business performance and position in the expanding e-business economy. MVC's unique, integrated approach enables companies to align their people, processes, and technologies in support of their business strategy. Global leaders in a wide variety of industries rely on MVC's proven methodologies, knowledge of products, professional expertise, and technical depth to extend their existing business models and seize new opportunities. MVC is based in Redwood Shores, California. http//www.mvsn.com.
Dr. Paul Dorsey is the founder and President of Dulcian, Inc. Dulcian specializes in Oracle client-server and web custom application development including developing new projects, auditing existing efforts, and rescuing failed projects. Paul is the Executive Editor of SELECT Magazine. He is the President of the New York Oracle Users’ Group. Paul and Peter Koletzke shared the Pinnacle Publishing Technical Achievement Award at ECO ‘95 for their work on a Forms template. Paul has won best presentation awards at both ECO and IOUW conferences and speaks at numerous Oracle conferences and user group meetings