Using the CREATE TYPE Statement

SQL was developed as the standard for relational databases. Within the past several years, technology has advanced, and object-oriented languages such as C++ and Java have emerged. Therefore, object orientation is now introduced in the new SQL standard. It is possible that object-oriented concepts could eventually supersede the SQL standard. There has been a large amount of time and energy invested to achieve the level of today's ANSI SQL. Therefore, ANSI SQL offers object orientation to preserve the language.

This technology is still fairly new, especially in a relational database environment. The concept of object orientation can be difficult to grasp unless you have studied an object-oriented language in the ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.