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