Start

Unternehmen

Business Solutions

Business Intelligence

Software-Technologien

Technologie-Beratung

Individual-Software

Comelio GmbH
Berlin
Fon: +49(0)30-3640339-80
Fax: +49(0)30-3640339-89
info@comelio.com

Comelio GmbH
Essen
Fon: +49(0)201-437517-0
Fax: +49(0)201-437517-10
info@comelio.com

Comelio GmbH
München
Fon: +49(0)89-38156860-0
Fax: +49(0)89-38156860-9
info@comelio.com

Comelio GmbH
Zürich
info@comelio.com

Inhalte

A. Object-Relational Elements

Object Types - Type Inheritance - Objects - Methods - Object Tables - Object Views - REF Datatype - Collections

B. Object Types and References

Null Objects and Attributes - Default Values for Objects and Collections - Constraints for Object Tables - Indexes for Object Tables and Nested Tables - Triggers for Object Tables - Rules for REF Columns and Attributes - Name Resolution

C. Methods

Member Methods - Methods for Comparing Objects: Map Methods, Order Methods, Guidelines, Comparison Methods in Type Hierarchies - Static Methods - Constructor Methods

D. Collections

Varrays - Nested Tables - Multilevel Collection Types: Nested Table Storage Tables, Varray Storage, Assignment and Comparison of Multilevel Collections - Creating a VARRAY or Nested Table - Constructors for Multilevel Collections - Querying Collections: Nesting Results of Collection Queries, Unnesting Results of Collection Queries, Unnesting Queries Containing Table Expression Subqueries, Unnesting Queries with Multilevel Collections, Performing DML Operations on Collections, Performing DML on Multilevel Collections

E. Type Inheritance

Types and Subtypes - FINAL and NOT FINAL Types and Methods - Creating Subtypes - NOT INSTANTIABLE Types and Methods - Inheriting, Overloading, and Overriding Methods - Dynamic Method Dispatch - Substituting Types in a Type Hierarchy - Attribute Substitutability - Column and Row Substitutability - Creating Subtypes After Creating Substitutable Columns - Dropping Subtypes After Creating Substitutable Columns - Turning Off Substitutability - Constraining Substitutability - Assignments Across Types - Comparisons: Objects, REF Variables, and Collections - Functions and Predicates Useful with Objects

F. Applying an Object Model to Relational Data

Object Views - Nesting Objects in Object Views - Identifying Null Objects in Object Views - Using Nested Tables and Varrays in Object Views - Specifying Object Identifiers for Object Views - Creating References to View Objects - Modelling Inverse Relationships with Object Views - Updating Object Views - Object View Hierarchies

Kontakt

Preise

Wenn Sie mehrere Seminarplätze gleichzeitig buchen, erhalten Sie für jeden Teilnehmer einen Preisvorteil nach folgender Tabelle. Alle Preise zzgl. 19% MwSt. Enthalten:

• Catering
• Mittagessen
• Literatur

Termine

9:00 - 16:30 Uhr | Inhouse-Termine auf Anfrage.

Ähnliche Seminare