O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

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

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 ...

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