Richard Walsh Earp Sikha Saha Bagui

Library of Congress Cataloging-in-Publication Data Earp, Richard, 1940Advanced SQL functions in Oracle 10g / by Richard Walsh Earp and Sikha Saha Bagui. p. cm. Includes bibliographical references and index. ISBN-13: 978-1-59822-021-6 ISBN-10: 1-59822-021-7 (pbk.) 1. SQL (Computer program language) 2. Oracle (Computer file). I. Bagui, Sikha, 1964-. II. Title. QA76.73.S67E26 2006 005.13'3--dc22 2005036444 CIP

© 2006, Wordware Publishing, Inc. All Rights Reserved 2320 Los Rios Boulevard Plano, Texas 75074 No part of this book may be reproduced in any form or by any means without permission in writing from Wordware Publishing, Inc. Printed in the United States of America

ISBN-13: 978-1-59822-021-6 ISBN-10: 1-59822-021-7 10 9 8 7 6 5 4 3 2 1 0601

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other brand names and product names mentioned in this book are trademarks or service marks of their