读取oracle long类型及判断是否自动分区表

CREATE or REPLACE function Find_Value
    ( av_owner varchar2, av_tname varchar2, av_pname varchar2)
RETURN varchar2

IS
  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;

  return long_var;
END;
/

 

SELECT table_owner, table_name, partition_name, Find_Value(table_owner, table_name, partition_name)
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博客 ” ，链接：http://blog.itpub.net/756652/viewspace-735052/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/756652/viewspace-735052/