DBMS_LOB.GETLENGTH(lob_loc  IN  BLOB/CLOB/BFILE/NCLOB) RETURN  INTEGER;

DBMS_LOB.OPEN(
    lob_loc    IN  OUT  NOCOPY  BLOB/CLOB/BFILE,
    open_mode  IN  BINARY_INTEGER    -- 只讀:DBMS_LOB.LOB_READONLY；讀寫：DBMS_LOB.LOB_READWRITE
);

DBMS_LOB.READ(
    lob_loc  IN  BLOB/CLOB/BFILE,     -- LOB 數(shù)據(jù)
    amount   IN  OUT  NOCOPY  BINARY_INTEGER),    -- IN:要讀取的字符數(shù)；OUT：實(shí)際讀取的字符數(shù)
    offset   IN  INTEGER,      --  起始位置
    buffer   OUT  RAW/VARCHAR2    -— 存儲(chǔ)返回?cái)?shù)據(jù)的變量
);

DBMS_LOB.WRITE(
    lob_loc  IN  OUT  NOCOPY  BLOB/CLOB,   -- 被寫入 LOB
    amount   IN  BINARY_INTEGER,   -- 寫入長(zhǎng)度(指寫入 LOB 數(shù)據(jù))
    offset   IN  INTEGER,          -- 寫入起始位置(指被寫入 LOB)
    buffer   IN  RAW/VARCHAR2      -- 寫入 LOB 的數(shù)據(jù)
);

DBMS_LOB.APPEND(
    dest_lob  IN  OUT  NOCOPY  BLOB,       --追加到的目標(biāo)LOB
    src_lob   IN  BLOB                     -- 用來追加的LOB
);

    DBMS_LOB.WRITEAPPEND(
        lob_loc  IN  OUT  NOCOPY  BLOB/CLOB/NCLOB,
        amount   IN  BINARY_INTEGER,
        buffer   IN  RAW/VARCHAR2
    );

DBMS_LOB.TRIM(
    lob_loc  IN  OUT  NOCOPY  BLOB/CLOB/NCLOB,   --LOB數(shù)據(jù)
    newlen   IN  INTEGER  -- 階段長(zhǎng)度
);

DBMS_LOB.CLOSE(lob_loc  IN  OUT  NOCOPY  BLOB/CLOB/BFILE); 

DBMS_LOB.SUBSTR(
    lob_loc  IN  BLOB/CLOB/BFILE,   -- 提取的來源
    amount   IN  INTEGER:=32762,   -- 提取長(zhǎng)度
    offset   IN  INTEGER:=1   -- 開始位置
)RETURN  RAW/VARCHAR2;   -- 提取到的內(nèi)容

DBMS_LOB.INSTR(
    lob_loc  IN  BLOB/CLOB/NCLOB/BFILE,
    pattern  IN  RAW/VARCHAR2,
    offset   IN  INTERGER:=1,
    nth      IN  INTEGER:=1
)RETURN  INTEGER;

DBMS_LOB.COMPARE(
    lob_1       IN  BLOB/CLOB/BFILE,
    lob_2       IN  BLOB/CLOB/BFILE,
    amount      IN  INTEGER:=4294967295,      --要比較的字符數(shù)(CLOB),字節(jié)數(shù)(BLOB)
    offset_1    IN  INTEGER:=1,               --lob_1 的起始位置
    offset_2    IN  INTEGER:=1                --lob_2 的起始位置
);

DBMS_LOB.ERASE(
    lob_loc  IN  OUT  NOCOPY  BLOB/CLOB/NCLOB,
    amount   IN  OUT  NOCOPY  INTEGER,        --字符/字節(jié)數(shù)
    offset   IN  INTEGER:=1                   —起始位置
);

DBMS_LOB.COPY(
    dest_lob     IN  OUT  NOCOPY  BLOB/CLOB/NCLOB,  -- 目標(biāo)的LOB
    src_lob      IN  BLOB/CLOB/NCOB,    -- 拷貝的來源的LOB
    amount       IN  INTEGER,           -- 拷貝的長(zhǎng)度
    dest_offset  IN  INTEGER:=1,        -- 目標(biāo)從哪里開始接收
    src_offset   IN  INTEGER:=1         -- 來源從來歷開始拷貝
);

DBMS_LOB.CREATETEMPORARY(
    lob_loc  IN  OUT  NOCOPY  BLOB/DLOB/NCLOB,
    cache    IN  BOOLEAN,     -- 是否將LOB讀取到緩沖區(qū)
    dur      IN  PLS_INTEGER:=10    -- 指定何時(shí)清除臨時(shí)LOB（10：會(huì)話結(jié)束時(shí)；12：調(diào)用結(jié)束時(shí)）
);

DBMS_LOB.ISTEMPORARY(lob_loc  IN  BLOB/CLOB/NCLOB)  RETURN  INTEGER;

DBMS_LOB.FILEEXISTS(file_loc  IN  BFILE) RETURN  INTEGER;

DBMS_LOB.FILEGETNAME(
    file_loc    IN  BFILE,
    dir_alias   OUT  VARCHAR2,
    filename    OUT  VARCHAR2
);

DBMS_LOB.FILEISOPEN(file_loc  IN  BFILE)  RETURN  INTEGER;

DBMS_LOB.FREETEMPORARY(lob_loc  IN  OUT  NOCOPY  BLOB/CLOB/NCLOB);

DBMS_LOB.FILEOPEN(
    file_loc   IN  OUT  NOCOPY  BFILE,
    open_mode  IN  BINARY_INTEGER:FILE_READONLY
);

DBMS_LOB.LOADBLOBFROMFILE(
    dest_loc     IN  OUT  NOCOPY  BLOB,
    src_bfile    IN  BFILE,
    amount       IN  INTEGER,
    dest_offset  IN  OUT  INTEGER,
    src_offset   IN  OUT  INTEGER
);

DBMS_LOB.FILECLOSE(FILE_LOC  IN  OUT  NOCOPY  BFILE);

DBMS_LOB.FILECLOSEALL();