读取oracle long类型及判断是否自动分区表
CREATE or REPLACE function Find_Value
( av_owner varchar2, av_tname varchar2, av_pname varchar2)
RETURN varchar2
( av_owner varchar2, av_tname varchar2, av_pname varchar2)
RETURN varchar2
IS
long_var LONG;
long_var LONG;
BEGIN
SELECT HIGH_VALUE INTO long_var
FROM DBA_TAB_PARTITIONS
WHERE table_owner = av_owner
AND table_name = av_tname and partition_name = av_pname;
SELECT HIGH_VALUE INTO long_var
FROM DBA_TAB_PARTITIONS
WHERE table_owner = av_owner
AND table_name = av_tname and partition_name = av_pname;
return long_var;
END;
/
END;
/
SELECT table_owner, table_name, partition_name, Find_Value(table_owner, table_name, partition_name)
FROM DBA_TAB_PARTITIONS where table_name='xxxxxx';
FROM DBA_TAB_PARTITIONS where table_name='xxxxxx';
SELECT table_name,interval FROM DBA_PART_TABLES WHERE TABLE_NAME IN ('GAMEDETAIL','GOODS_ROLELOCK_DETAIL');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-735052/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
