Books for you

You must use either the DBMS_LOB PL/SQL builtin
package or the OCI interface to actually manipulate the data in a LOB.
To facilitate the conversion of LONG datatypes to LOBs, Oracle9i included support
for LOBs in most functions that support LONGs, as well as an option to the
ALTER TABLE statement that allows the automatic migration of LONG
datatypes to LOBs.
BFILE
The BFILE datatype acts as a pointer to a file stored outside of the Oracle database.
Because of this fact, columns or variables with BFILE datatypes don??™t
participate in transactions, and the data stored in these columns is available only
for reading. The file size limitations of the underlying operating system limit the
amount of data in a BFILE.
XMLType
As part of its support for XML, Oracle9i introduced a datatype called XMLType.
A column defined as this type of data will store an XML document in a
character LOB column. There are built-in functions that allow you to extract
individual nodes from the document, and you can also build indexes on any particular
node in the XMLType document.


Pages:
184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208