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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.