select * from (
select 'url' as url, ID as id ,PRESENTNAME as PresentnameTitle,PRESENTTXT as PresenttxtTxt,PRESENTPRICE as PresentpriceRe,PRESENTREMARK as PresentpricereType
from PRESENT where STATE=1
union
select 'url' as url, ID as id ,tovarchar(nvl(Title,empty_clob())) as PresentnameTitle, tovarchar(nvl(Txt,empty_clob())) as PresenttxtTxt, tovarchar(nvl(REMARK,empty_clob())) as PresentpriceRe, TYPE||'' as PresentpricereType
from ZHONGHONGHONOR
where STATE=1
)
where PresentnameTitle like '%丰裕%' or PresenttxtTxt like '%丰裕%' or PresentpriceRe like '%丰裕%';
指定的LOB定位器无效
在sys.dbms_LOB
在Leno.tovarchar
( param1 in clob
) return varchar2 as
v_offset NUMBER := 1;
v_size NUMBER := 4000;
v_buf VARCHAR2(8000);
begin
dbms_lob.read(param1, v_size, v_offset, v_buf);--读取数据到缓冲区
return v_buf;
end tovarchar;