The Oracle database has been able to store
large objects for some time. Oracle8 added the capability to store multiple LOB columns
in each table. Oracle Database 10g essentially removed the space limitation on
large objects. Oracle Database 11g greatly improved the performance of query and
insert operations used with LOBs through the introduction of SecureFiles. Transparent
data encryption is supported for SecureFiles LOB data.
Database Application Development Features | 11
Object-oriented programming
Support of object structures has existed since Oracle8i to provide support for an
object-oriented approach to programming. For example, programmers can create
user-defined datatypes, complete with their own methods and attributes. Oracle??™s
object support includes a feature called Object Views through which object-oriented
programs can make use of relational data already stored in the database. You can
also store objects in the database as varying arrays (VARRAYs), nested tables, or
index organized tables (IOTs). We discuss the object-oriented features of Oracle further
in Chapter 14.
Pages:
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58