BLOB A binary large object; the maximum size is (4GB ??“ 1) * DB_BLOCK_SIZE.
BFILE A pointer to a large binary file stored outside the database. Binary files
must be accessible from the server running the Oracle instance. The
maximum size is 4GB.
TABLE 1-1 Oracle Built-in Datatypes (continued)
ANSI SQL Datatype Oracle Datatype
CHARACTER(n)
CHAR(n)
CHAR(n)
CHARACTER VARYING(n)
CHAR VARYING(n)
VARCHAR(n)
NATIONAL CHARACTER(n)
NATIONAL CHAR(n)
NCHAR(n)
NCHAR(n)
NATIONAL CHARACTER VARYING(n)
NATIONAL CHAR VARYING(n)
NCHAR VARYING(n)
NVARCHAR2(n)
NUMERIC(p,s)
DECIMAL(p,s)
NUMBER(p,s)
INTEGER
INT
SMALLINT
NUMBER(38)
FLOAT(b)
DOUBLE PRECISION
REAL
NUMBER
TABLE 1-2 ANSI-Equivalent Oracle Datatypes
Chapter 1: Getting Started with the Oracle Architecture 11
Temporary Tables
Temporary tables have been available since Oracle8i. They are temporary in the sense of the data
that is stored in the table, not in the definition of the table itself. The command create global
temporary table creates a temporary table.
As long as other users have permissions to the table itself, they may perform select statements
or Data Manipulation Language Commands (DML), such as insert, update, or delete, on a temporary
table. However, each user sees their own and only their own data in the table. When a user
truncates a temporary table, only the data that they inserted is removed from the table.
There are two different flavors of temporary data in a temporary table: temporary for the
duration of the transaction, and temporary for the duration of the session.
Pages:
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67