Application Developer’s Guide - Object-Relational Features

Oracle object technology is a layer of abstraction built on Oracle relationaltechnology. New object types can be created from any built-in database types andany previously created object types, object references, and collection types.Metadata for user-defined types is stored in a schema that is available to SQL,PL/SQL, Java, and other published interfaces
Nội dung trích xuất từ tài liệu:
Application Developer’s Guide - Object-Relational FeaturesOracle® DatabaseApplication Developer’s Guide - Object-Relational Features10g Release 1 (10.1)Part No. B10799-01December 2003Oracle Database Application Developers Guide - Object-Relational Features, 10g Release 1 (10.1)Part No. B10799-01Copyright © 1996, 2003 Oracle Corporation. All rights reserved.Contributors: Geeta Arora, Eric Belden, Chandrasekharan Iyer, Geoff Lee, Anand Manikutty, ValarieMoore, Magdi Morsi, Helen Yeh, Adiel Yoaz, Qin YuThe Programs (which include both the software and documentation) contain proprietary information ofOracle Corporation; they are provided under a license agreement containing restrictions on use anddisclosure and are also protected by copyright, patent and other intellectual and industrial propertylaws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent requiredto obtain interoperability with other independently created software or as specified by law, is prohibited.The information contained in this document is subject to change without notice. If you find any problemsin the documentation, please report them to us in writing. Oracle Corporation does not warrant that thisdocument is error-free. Except as may be expressly permitted in your license agreement for thesePrograms, no part of these Programs may be reproduced or transmitted in any form or by any means,electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.If the Programs are delivered to the U.S. Government or anyone licensing or using the programs onbehalf of the U.S. Government, the following notice is applicable:Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are commercialcomputer software and use, duplication, and disclosure of the Programs, including documentation,shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.Otherwise, Programs delivered subject to the Federal Acquisition Regulations are restricted computersoftware and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500Oracle Parkway, Redwood City, CA 94065.The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherentlydangerous applications. It shall be the licensees responsibility to take all appropriate fail-safe, backup,redundancy, and other measures to ensure the safe use of such applications if the Programs are used forsuch purposes, and Oracle Corporation disclaims liability for any damages caused by such use of thePrograms.Oracle is a registered trademark, and Oracle9i, Oracle Store, PL/SQL, Pro*C, Pro*C/C++, and SQL*Plusare trademarks or registered trademarks of Oracle Corporation. Other names may be trademarks of theirrespective owners. ContentsSend Us Your Comments ................................................................................................................ xiiiPreface........................................................................................................................................................... xv Audience ............................................................................................................................................... xvi Organization......................................................................................................................................... xvi Related Documentation ..................................................................................................................... xvii Conventions........................................................................................................................................ xviii Documentation Accessibility ............................................................................................................. xxiWhats New in Object-Relational Features? ....................................................................... xxiii Oracle 10g Release 1 (10.1) New in Object-Relational Features .................................................. xxiv Oracle9i Release 2 (9.2) New in Object-Relational Features ........................................................ xxiv Oracle9i Release 1 (9.0.1) New in Object-Relational Features ...................................................... xxv1 Introduction to Oracle Objects About Oracle Objects......................................................................................................................... 1-2 Advantages of Objects ....................................................................................................................... 1-2 Key Features of the Object-Relational Model............................................................................... 1-3 Core Database Key Features ....................................................................................................... 1-4 Object Types ........................................................................................................................... 1-4 Objects ..................................................................................................................................... 1-5 Object Methods ...................................................................................................................... 1-6 Type Inheritance ...