O'Reilly logo

Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding the ORDSYS data types

This section covers methods for creating and working with tables using the Oracle Multimedia data types. Further information on each of the types can be found in Appendix E, Loading and Reading.

Creating a table

As the ORDSYS Multimedia types reference ORDSYS.ORDSOURCE, which in turn references a BLOB, the database administrator has the option of specifying all the storage parameters for each of the columns. For example, the table created looks like the following:

create table myimage(
 pk number,
 myphoto ORDSYS.ORDIMAGE,
 myvideo ORDSYS.ORDVIDEO
)

The resulting storage parameters would like like the following:

create table myimage ( pk number, myphoto ORDSYS.ORDIMAGE, myvideo ORDSYS.ORDVIDEO ) tablespace relational_tbls ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required