教学讲稿oracle官方11g_les07.pptVIP

Manipulating Large Objects Objectives After completing this lesson, you should be able to do the following: Compare and contrast LONG and large object (LOB) data types Create and maintain LOB data types Differentiate between internal and external LOBs Use the DBMS_LOB PL/SQL package Describe the use of temporary LOBs Lesson Agenda Introduction to LOBs Managing BFILEs by using the DBMS_LOB package Migrating LONG data types to LOBs Manipulating LOB data Using temporary LOBs What Is a LOB? LOBs are used to store large, unstructured data such as text, graphic images, films, and sound waveforms. Contrasting LONG and LOB Data Types Components of a LOB The LOB column stores a locator to the LOB’s value. Internal LOBs The LOB value is stored in the database. Managing Internal LOBs To interact fully with LOB, file-like interfaces are provided in: PL/SQL package DBMS_LOB Oracle Call Interface (OCI) Oracle Objects for object linking and embedding (OLE) Pro*C/C++ and Pro*COBOL precompilers Java Database Connectivity (JDBC) The Oracle server provides some support for LOB management through SQL. Lesson Agenda Introduction to LOBs Managing BFILEs by using the DBMS_LOB package Migrating LONG data types to LOBs Manipulating LOB data Using temporary LOBs What Are BFILEs? The BFILE data type supports an external or file-based large object as: Attributes in an object type Column values in a table Securing BFILEs What Is a DIRECTORY? Guidelines for CreatingDIRECTORY Objects Do not create DIRECTORY objects on paths with database files. Limit the number of people who are given the following system privileges: CREATE ANY DIRECTORY DROP ANY DIRECTORY All DIRECTORY objects are owned by SYS. Create directory paths and properly set permissions before using the DIRECTORY object so that the Oracle server can read the file. Using the DBMS_LOB Package Working with LOBs often requires the use of the Oracle-supplied DBMS_LOB package. DBMS_LOB provides routines to access and manipulate internal