|Lesson 4||The DBMS_LOB package|
|Objective||Describe the components of the DBMS_LOB package.|
APPEND(): Append the contents of the source LOB to the destination LOB.
COPY(): Copy all or part of the source LOB to the destination LOB.
ERASE(): Erase all or part of a LOB.
LOADFROMFILE(): Load BFILE data into an internal LOB.
TRIM(): Trim the LOB value to the specified shorter length.
WRITE(): Write data to the LOB from a specified offset.
COMPARE(): Compare two entire or part of two LOBs.
GETLENGTH(): Get the length of the LOB value.
INSTR(): Return the matching position of the nth occurrence of the pattern within the LOB.
READ(): Read data from the LOB starting at the specified offset.
SUBSTR(): Return part of the LOB value starting at the specified offset.
FILECLOSEALL(): Close all previously opened files.
FILEEXISTS(): Check if the file exists on the server.
FILEGETNAME(): Get the directory alias and filename.
FILEISOPEN(): Check if the file was opened using the input BFILE locators.
FILEOPEN(): Open a file.