DBMS_Utility学习
来源:互联网 发布:java mysql 时区设置 编辑:程序博客网 时间:2024/06/06 07:18
Comma_to_table
以下是例子:
DECLARE v_len BINARY_INTEGER; v_tab DBMS_UTILITY.UNCL_ARRAY; v_idx BINARY_INTEGER; v_str VARCHAR2(200); BEGIN DBMS_UTILITY.COMMA_TO_TABLE ( 'a,b,c', --每个元素必须符合Oracle命名规约,即:不能以数字开头 v_len, v_tab); v_idx := v_tab.FIRST; WHILE(v_idx IS NOT NULL) LOOP dbms_output.put_line(v_tab(v_idx)); v_idx := v_tab.NEXT(v_idx); END LOOP; dbms_utility.Table_to_Comma(v_tab, v_len, v_str); dbms_output.put_line(v_str);END;
a
b
c
a,b,c
dbms_utility.GET_DEPENDENCY
取得数据库各对象之间依赖关系。给出一个例子演示:CREATE VIEW SAL_SUMMARY_BY_DEPT AS SELECT DEPTNO, SUM(SAL) SAL FROM emp GROUP BY DEPTNO;EXEC dbms_utility.GET_DEPENDENCY('TABLE','SCOTT','EMP');
DEPENDENCIES ON SCOTT.EMP
------------------------------------------------------------------
*TABLE SCOTT.EMP()
* VIEW SCOTT.SAL_SUMMARY_BY_DEPT()
也可以实用User_Dependencies(dba_dependencies, all_dependencies)来获取依赖关系
SELECT * FROM user_dependencies WHERE REFERENCED_NAME = 'EMP';
dbms_utility.get_hash_value
To get a hash value on a string where the hash value should be between 1000 and 3047, use 1000 as the base value and 2048 as the hash_size value.Using a power of 2 for the hash_size parameter works best.
SELECT DBMS_UTILITY.GET_HASH_VALUE('A', 0,2048) hash_value FROM dual;
dbms_util.get_cpu_time
返回值number类型,精确到百分之一秒。
0 0
- DBMS_Utility学习
- dbms_utility.get_time
- DBMS_UTILITY.GET_TIME与DBMS_UTILITY.GET_CPU_TIME
- DBMS_UTILITY.GET_CPU_TIME和DBMS_UTILITY.GET_TIME
- Oracle DBMS_UTILITY.GET_TIME与DBMS_UTILITY.GET_CPU_TIME区别
- Oracle dbms_utility 包用法
- Oracle dbms_utility.get_time
- Oracle DBMS_UTILITY 用法例子
- Oracle DBMS_UTILITY.GET_HASH_VALUE
- DBMS_UTILITY.EXEC_DDL_STATEMENT提示无权限
- dbms_utility.table_to_comma使用的注意点
- 利用DBMS_UTILITY.GET_HASH_VALUE 给文本建立索引
- dbms_utility获取CPU时间(get_cpu_time)
- 記錄執行一條一句需要多長時間:oracle dbms_utility.get_time函数
- Oracle dbms_utility 几种返回的错误
- DBMS_UTILITY.get_time——比较时间差
- oracle中dbms_utility.get_hash_value与ora_hash
- 获取异常的具体出处dbms_utility.format_error_backtrace
- Oracle Query Result Cache
- Android学习---解决Android Graphical Layout 界面效果不显示
- USB转串口 FT232/PL2303/CH340 驱动以及使用体会
- Hibernate中polymorphism=”explicit”和polymorphism=”implicit”区别
- compare gsm cdma
- DBMS_Utility学习
- Struts工作流程
- JS编码
- wxpython画板例子
- ubuntu安装p7zip
- Open the Android native Camera using OpenCV
- Oracle Deterministic Function
- make module失败的原因cc1: error: unrecognized command line option "-m64"
- Hadoop集群问题汇总