-- Start
BLOB
DECLARE
-- BINARY LARGE OBJECT 是 BLOB 的子类型
TEST1 BLOB := EMPTY_BLOB();
TEST2 BINARY LARGE OBJECT := EMPTY_BLOB();
BEGIN
DBMS_OUTPUT.PUT_LINE('TEST1=');
END;
/
CLOB
DECLARE
-- CLOB 数据类型
TEST1 CLOB := EMPTY_CLOB();
-- CHAR LARGE OBJECT 是 CLOB 的子类型
TEST2 CHAR LARGE OBJECT := EMPTY_CLOB();
-- CHARACTER LARGE OBJECT 是 CLOB 的子类型
TEST2 CHARACTER LARGE OBJECT := EMPTY_CLOB();
BEGIN
DBMS_OUTPUT.PUT_LINE('TEST1=');
END;
/
NCLOB
DECLARE
-- NCLOB 数据类型
TEST1 NCLOB := EMPTY_CLOB();
-- NCHAR LARGE OBJECT 是 NCLOB 的子类型
TEST2 NCHAR LARGE OBJECT := EMPTY_CLOB();
-- NATIONAL CHARACTER LARGE OBJECT 是 NCLOB 的子类型
TEST2 NATIONAL CHARACTER LARGE OBJECT := EMPTY_CLOB();
BEGIN
DBMS_OUTPUT.PUT_LINE('TEST1=');
END;
/
BFILE
DECLARE
-- BFILE 数据类型
TEST1 BFILE := BFILENAME('D:\Dev\Oracle\SQL', 'Oracle Database SQL Language Reference 12.1.txt');
BEGIN
DBMS_OUTPUT.PUT_LINE('TEST1=');
END;
/
--更多参见:Oracle PL/SQL 精萃
-- 声明:转载请注明出处
-- Last Edited on 2015-01-01
-- Created by ShangBo on 2015-01-01
-- End