Oracle Application Express 4 Recipes
Copyright 2011 by Edmund Zehoo
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-4302-3506-4
ISBN-13 (electronic): 978-1-4302-3507-1
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights.
President and Publisher: Paul Manning
Lead Editor: Jonathan Gennick
Technical Reviewer: Guillermo Alan Bort
Editorial Board: Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Jonathan Gennick,
Jonathan Hassell, Michelle Lowman, James Markham, Matthew Moodie, Jeff Olson, Jeffrey
Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke, Dominic Shakeshaft, Matt
Wade, Tom Welsh
Coordinating Editor: Anita Castro
Copy Editor: Mary Behr
Compositor:Bytheway Publishing Services
Indexer: John Collin
Artist: April Milne
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer Science+Business Media, LLC., 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail .
For information on translations, please e-mail .
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use. eBook versions and licenses are also available for most titles. For more information, reference our Special Bulk SaleseBook Licensing web page at www.apress.com/bulk-sales
.
The information in this book is distributed on an as is basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.
The source code for this book is available to readers at www.apress.com
. You will need to answer questions pertaining to this book in order to successfully download the code.
To my family,
for you are truly all I have.
Contents at a Glance
Contents
About the Author
Edmund Tan Zehoo is the Chief Technical Officer of an e-forms and workflows solution vendor based in Singapore. He took the role of lead architect in the design of several Rapid Application Development and workflow products, one of the most popular being the Rapidflows product. He has also spent the last eight years building performance-critical .NET solutions hosted on top of Oracle databases for large companies and governmental institutions in Singapore.
Edmund is a frequent speaker at various workflow conferences in Singapore and Malaysia, and he continually preaches about the synergistic power of using Oracle with the .NET framework. During his free time, he likes to explore the inner workings of the brain and mind, with the ultimate goal of writing intelligent software to emulate the behavior of the mind. He is also an avid believer in the Technological Singularity.
About the Technical Reviewer
Guillermo Alan Bort started working as First Line Support for Oracle customers before the support model switched to web-based Oracle Support. In the beginning, his area of interest was Linux System Administration, Oracle Database, and Oracle Applications; later, he focused on Oracle Database, working with high availability and disaster recovery scenarios in large scale environments. He supported several companies with outsourced database administration services and developed several APEX applications to control and share information across a multiregional team.
Acknowledgments
This book is the result of the combined efforts of a team of wonderful people with whom I've had the pleasure of working. I'll start with a special word of thanks to my editor Jonathan Gennick: thanks for giving this author halfway around the world a chance. Your encouraging remarks and insightful edits constantly remind me that authoring a book can indeed be so much fun.