Oracle SQL Jumpstart with Examples- P1

Oracle SQL Jumpstart with Examples- P1: Review"As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single...
Nội dung trích xuất từ tài liệu:
Oracle SQL Jumpstart with Examples- P1Please purchase PDF Split-Merge on www.verypdf.com to remo Oracle SQL Jumpstart with ExamplesPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. This page intentionally left blankPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Oracle SQL Jumpstart with Examples Gavin Powell Carol McCullough-Dieter AMSTERDAM • BOSTON • HEIDELBERG • LONDON NEW YORK • OXFORD • PARIS • SAN DIEGO• SAN FRANCISCO • SINGAPORE • SYDNEY • TOKYOPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Elsevier Digital Press 200 Wheeler Road, Burlington, MA 01803, USA Linacre House, Jordan Hill, Oxford OX2 8DP, UK Copyright © 2005, Elsevier Inc. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. Permissions may be sought directly from Elsevier’s Science & Technology Rights Department in Oxford, UK: phone: (+44) 1865 843830, fax: (+44) 1865 853333, e-mail: permissions@elsevier.com.uk. You may also complete your request on-line via the Elsevier homepage (http://elsevier.com), by selecting “Customer Support” and then “Obtaining Permissions.” Recognizing the importance of preserving what has been written, Elsevier prints its books on acid-free paper whenever possible. Library of Congress Cataloging-in-Publication Data Application submitted. ISBN: 1-55558-323-7 British Library Cataloguing-in-Publication Data A catalogue record for this book is available from the British Library. For information on all Digital Press publications visit our Web site at www.digitalpress.com and www.bh.com/digitalpress 04 05 06 07 08 09 10 9 8 7 6 5 4 3 2 1 Printed in the United States of AmericaPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Contents at a Glance Foreword xix Preface xxi Acknowledgements xxix 1 Introduction to Oracle SQL 1 2 New Features of Oracle SQL 39 3 Oracle Database Architecture 51 4 The SELECT Statement 73 5 Filtering Rows 97 6 Sorting Rows 109 7 Operators, Conditions, and Pseudocolumns 123 8 Using SQL*Plus 137 9 Single-Row Functions 175 10 Joining Tables 205 11 Grouping and Summarizing Data 235 12 Subqueries 267 13 Unusual Query Types 285 14 Expressions 301 15 Data Manipulation Language (DML) 315 16 Datatypes and Collections 339 vPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. vi Contents at a Glance 17 XML in Oracle 357 18 Tables 383 19 Views 425 20 Constraints 447 21 Indexes and Clusters 471 22 Sequences and Synonyms 489 23 Security 503 24 Basic PL/SQL 531 Append ...