smse10_管理表对象.pptVIP

Managing Tables管理表 Objectives After completing this lesson, you should be able to do the following: Identify the various methods of storing data Outline Oracle data types Distinguish between an extended versus a restricted ROWID Outline the structure of a row Create regular and temporary tables Manage storage structures within a table Manage index-organized table,clusters and partitioned table Reorganize, truncate, drop a table Add, Drop or modify a column within a table Obtain table information Distribution of Rows Within a Table Oracle Data Types Representing Numeric Data Use the NUMBER datatype to store real numbers in a fixed-point or floating-point format. Numbers using this datatype are guaranteed to be portable among different Oracle platforms, and offer up to 38 decimal digits of precision. Oracle 9i DateTime Support INTERVAL YEAR TO MONTH Data Type INTERVAL YEAR TO MONTH stores a period of time using the YEAR and MONTH datetime fields. Data Types for Storing Large Objects Oracle provides six data types for storing LOBs CLOB and LONG for large fixed-width character data NCLOB for large fixed-width national character set data BLOB and LONG RAW for storing unstructured data BFILE for storing unstructured data in operating system files There are two distinct parts of LOB :LOB value and locator. The LOB column stores a locator to the LOB’s value Data Types for Storing Large Objects Data Types for Storing Large Objects External LOBs(BFILE):Store a locator to the physical file. Definition of BFILE objects Association of BFILE object to corresponding external files Security for BFILEs Data Types for Storing Large Objects Internal LOBs: the LOB value is stored in the database Managing internal LOBs PL/SQL package DBMS_LOB Oracle Call Interface(OCI) Oracle Objects for object linking and embedding ODBC/JDBC SQL ROWID Data Type Unique identifier for each row in the database. Does not stored explicitly as a column value. Although the ROWID does not directly give t