Oracle Clob\Blob 初始化

 

-- Initializing LOB Columns Added to a Table
-- 添加列
alter table employees add (resume clob,picture blob);

-- 初始化
create table emp_hiredata(
  employee_id number(6),
  full_name varchar2(45),
  resume clob default empty_clob(),
  picture blob default empty_blob()
);