CRITICAL SKILL 1.5

Work with Stored Objects

Oracle Database 10g offers the ability to store user-defined programming units in the data dictionary, called stored objects. These programming units are written in PL/SQL, the topic of Chapter 7. Without worrying about what goes inside these objects, let’s do an overview of what they are all about.

image

TABLE 1-3. Following Relationships Between Tables

Ask the Expert

Q: What is the major difference between the clob and blob data types in Oracle Database 10g?

A: The clob stores only alphanumeric data, whereas the blob can accommodate any type of data, including sound and video.

Q: When specifying the number ...

Get Oracle Database 10g: A Beginner's Guide 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.