Databases Reference
In-Depth Information
DBMS_LOB
This package provides procedures to work with BLOBs, CLOBs, NCLOBs, BFILEs, and
temporary LOBs.
Procedures
The most relevant procedures are:
F
GET_LENGTH
: gets the length of the LOB value
F
FILEOPEN
: opens a file
F
LOADFROMFILE
: loads LOB data from a file
F
APPEND
: appends the contents of a source LOB to a destination LOB
F
OPEN
: opens an LOB
F
READ
: reads data from the LOB starting at the specified offset
F
WRITE
: writes data to the LOB from a specified offset
F
CLOSE
: closes a previously opened LOB
DBMS_MVIEW
This package helps the management of Materialized Views, refreshes them and helps
understanding the capabilities for materialized views and potential materialized views.
Procedures
The most relevant procedures are:
F
EXPLAIN_MVIEW
: explains what is possible with a materialized view or potential
materialized view
F
EXPLAIN_REWRITE
: explains why a query failed to rewrite or why the optimizer
chose to rewrite a query with a particular materialized view(s)
F
REFRESH
: refreshes one or more materialized views
F
REFRESH_ALL_MVIEWS
: refreshes all the materialized views
DBMS_OUTLN
This package contains the functional interface to manage stored outlines.
To use this package the
EXECUTE_CATALOG_ROLE
role is needed. There is also a public
synonym
OUTLN_PKG
.