oracle 12c 转入 10g,oracle long to char转换(oracle 11g 10g)

oracle long to char转换(oracle 11g 10g)

2020年07月18日

| 萬仟网IT编程

 | 我要评论

### Code ReferenceURL:https://blog.csdn.net/paul50060049/article/details/78811957DESC:oracle long to char转换(oracle 11g 10g)Last Update:2020-7-17 22:00Time：2020-7-17 22:00 Tittle：标题Version:001oracle long to char转换(oracle 11g 10g) -- 验证long to ch

### Code Reference

URL:https://blog.csdn.net/paul50060049/article/details/78811957

DESC:oracle long to char转换(oracle 11g 10g)

Last Update:2020-7-17 22:00

Version:001

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

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！

相关文章:

原因：Load窗体时，窗体未显示 解决：1、Focus()之前添加this.Show(); 2、在Shown事件中添加Focus() ...

...

在 Web 应用程序开发过程中，总是无法避免涉及到文件上传，这次我们来聊一聊怎么去实现一个简单方便可复用文件上传功能；通过创建自定义绑定模型来实现文...