oracle long to char转换(oracle 11g 10g)
-- 验证long to char
select a.column_name,
b.constraint_name,
b.constraint_type,
instr(fun_long2char(b.constraint_name, a.owner), ' IS NOT NULL')
from dba_cons_columns a, dba_constraints b
where a.constraint_name = b.constraint_name
and a.owner = b.owner
and b.constraint_type in ('P', 'R', 'U', 'C', 'V', 'O', 'H', 'F', 'S')
and instr(fun_long2char(b.constraint_name, a.owner), ' IS NOT NULL') = 0
-- 转化方法
create or replace function fun_long2char(pv_constraintname in varchar2,
pv_owner in varchar2)
return varchar2 as
lv_text varchar2(32000);
begin
select search_condition
into lv_text
from dba_constraints t
where upper(t.constraint_name) = upper(pv_constraintname)
and upper(t.owner) = upper(pv_owner);
lv_text := substr(nvl(lv_text, ''), 1, 500);
return lv_text;
end fun_long2char;
本文地址:https://blog.csdn.net/u011078141/article/details/107418843
如对本文有疑问, 点击进行留言回复!!
(精华)2020年7月21日 ASP.NET Core 容器伪属性注入
网友评论